Microsoft Excel 2007 – Hiding 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. 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.

The worksheet is immediately hidden. Once hidden, there is no way to tell that it is "missing. If you later want to unhide the worksheet, follow the steps above and click “unhide”.