Microsoft Office Tutorials and References
In Depth Information
Hide a Worksheet
Chapter 9: Protecting Excel Data
Unhide a Worksheet
1 Click the Home tab.
2 Click Format.
3 Click Hide & Unhide.
4 Click Unhide Sheet.
You can also right-click
any worksheet tab and
then click Unhide Sheet.
The Unhide dialog box
5 Click the worksheet you
want to restore.
6 Click OK.
Excel returns the
worksheet to the
If you have several worksheets that you need to hide, you do not have to hide them
individually. Instead, you can select all the sheets you want to work with and then hide
them. To select multiple worksheets, click the tab of one of the worksheets, hold down
the Ctrl key, and then click the tabs of the other worksheets.
If your workbook has many worksheets and you want to hide most of them, an easy
way to select the sheets is to right-click any worksheet tab and then click Select All
Sheets. Hold down the Ctrl key, and then click the tabs of the worksheets that you do
not want to hide.
After you have selected your worksheets, follow steps 2 to 5 in the “Hide a Worksheet”
section to hide all the selected worksheets at once.