Hiding and Unhiding Excel 2007 Worksheets
In Excel 2007, you can hide any worksheet in a workbook to remove it from view so that others cannot see the data it contains. You can unhide the worksheet at any time.
All formula references to a hidden worksheet are still valid even when a worksheet is hidden.
1
Click anywhere on the worksheet that you want to hide.
You can select multiple worksheets if you want to hide more than one worksheet at a time.
2
In the Cells group on the Home tab, choose Format→Hide & Unhide→Hide Sheet.
Excel hides the worksheet from view.
3
To unhide the worksheet, choose Format→Hide & Unhide→Unhide Sheet.
The Unhide dialog box appears, listing all currently hidden worksheets in the active workbook.
4
Select the worksheet you want to unhide and click OK.
The worksheet appears in the workbook.
