Show or hide sheets

Note: This article has done its job, and will be retiring soon. To prevent "Page not found" woes, we're removing links we know about. If you've created links to this page, please remove them, and together we'll keep the web connected.

When you work with large amounts of data, hiding sheets may help you do your work with less distraction. When you have to summarize information for other people, hiding the details may help them focus on your conclusions.

When you use password protection, data in hidden sheets can be locked from other viewers of the workbook. For more information about workbook protection, see Protect a workbook.

Note: Hiding data does not affect calculations or formulas.

Do any of the following:

Hide sheets

  1. Click the sheet that you want to hide.

  2. On the Format menu, point to Sheet, and then click Hide.

    Note: If Hide is unavailable, the structure of your workbook may be protected. For more information about workbook protection, see Protect a workbook.

Show sheets

  1. On the Format menu, point to Sheet, and then click Unhide.

    Note: If Unhide is unavailable, you may not have a hidden sheet, or the structure of your workbook may be protected. For more information about workbook protection, see Protect a workbook.

  2. In the Unhide dialog box, click the name of the sheet that you wish to display.

Unhide sheets

  1. Hold down CONTROL and click one of the visible sheet tabs, and then click Unhide.

  2. In the Unhide dialog box, click the sheet that you want to show, and then click OK.

See also

Insert or delete cells, rows, columns

Move or copy a sheet

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×