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:

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

Move or copy a sheet