Hiding and Unhiding Worksheets

There may be times when you want to hide a particular worksheet so that it cannot be easily accessed. This is often done to protect information on a worksheet or keep it from prying eyes. To hide a worksheet, follow these steps:

1. Select the worksheet you want to hide.
2. Choose Sheet from the Format menu. Excel displays a submenu.
3. Choose the Hide option from the submenu.

The worksheet is immediately hidden. Once hidden, there is no way to tell it is "missing," as there is with hidden rows and columns. If you later want to unhide the worksheet, follow these steps:

1. Choose Sheet from the Format menu. Excel displays a submenu.
2. Choose Unhide from the submenu. (This option is available only if there are hidden worksheets in the workbook.) Excel displays the Unhide dialog box. (Click here to see a related figure.)
3. Select the worksheet name you want to unhide.
4. Click on OK.