Teach MeShow MeLet Me TryPrint

Hiding and Unhiding Worksheets

When you hide a worksheet the data still remains in your workbook, but it is no longer displayed onscreen and is not part of the printed workbook. Hiding worksheets can be helpful when you want to avoid working on the wrong worksheet in a workbook that contains several worksheets. At any time, you can choose to "unhide" a worksheet, which will redisplay it.

To hide a worksheet:

  1. Select the worksheet you want to hide.
  2. Click the Format menu, point to Sheet, and select Hide.

To unhide a worksheet:

  1. Click the Format menu, point to Sheet, and select Unhide...
  2. In the Unhide dialog box, click the name of the sheet you want to unhide.
  3. Click OK.

If you plan on printing your entire workbook, you should first hide worksheets you do not want to print.
When you hide a worksheet, it will remain hidden until you unhide it. If you save a workbook with a worksheet hidden, the next time you open the workbook, the sheet will remain hidden.