Show or hide sheets

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:

ShowHide 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.

ShowShow 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.

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

ShowUnhide 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, or sheets

Move or copy a sheet

 
 
Applies to:
Excel for Mac 2011