Hide A Worksheet In Excel

A workbook can contain multiple worksheets. You may want others to be able to view data on one worksheet in the workbook but not another. One thing you can do to achieve this is hide the worksheet. By doing so, the data in the worksheet in no longer visible, but not deleted.

To hide a worksheet in Excel 2002:

  1. Click the worksheet that you want to hide.
  2. From the Format menu, point to Sheet, and then click Hide.

To unhide a worksheet, click the Format menu, point to Sheet, and click Unhide. A dialog box will appear listing any hidden worksheets. Click the worksheet you want to unhide and click OK.

[tags]excel, microsoft office[/tags]

Article Written by

  • Patricio Rivero

    Can you conditionally hide rows similarly to conditional formatting?