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 if you are using Excel 2007:

1. Select the worksheet you want to hide.
2. Display the Home tab of the ribbon.
3. In the Cells group, click the Format tool. Excel displays a menu.
4. Choose Hide & Unhide, and then choose Hide Sheet.

If you are using an older version of Excel you can hide a worksheet using 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 in Excel 2007:

1. Display the Home tab of the ribbon.
2. In the Cells group, click the Format tool. Excel displays a menu.
3. Choose Hide & Unhide, and then choose Unhide Sheet. Excel displays the Unhide dialog box.
4. Select the worksheet name you want to unhide.
5. Click on OK.

In older versions of Excel you unhide worksheets using these steps:

1. Choose Sheet from the Format menu. Excel displays a submenu.
2. Choose Unhide from the submenu. This displays the Unhide dialog box.
3. Select the worksheet name you want to unhide.
4. Click on OK.