Posted by Kiran

All of us know that Microsoft Excel allows us to hide certain worksheets from view. Hiding sheets helps us in ensuring that any background lookup data or reference data that you want to utilize in your spreadsheets remain neatly tucked away from general view.

You may also want to prevent users from viewing certain numbers that are used in calculation on your spreadsheets. Hiding worksheets simply makes the workbook clutter free and helps readers focus on the spreadsheets that really matter.

The only disadvantage with simply hiding your worksheets is that it is equally easy to unhide them. Any Excel user worth his salt knows how to find and unhide a hidden sheet. To prevent users from unhiding your worksheets, you may choose to protect the workbook. However when you protect a workbook, you are also preventing the users from a myriad of other functionality that they may genuinely require.