Hiding and Unhiding Excel 2007 Worksheets

In Excel 2007, you can hide any worksheet in a workbook to remove it from view so that others cannot see the data it contains. You can unhide the worksheet at any time.

All formula references to a hidden worksheet are still valid even when a worksheet is hidden.

1

Click anywhere on the worksheet that you want to hide.

You can select multiple worksheets if you want to hide more than one worksheet at a time.

2

In the Cells group on the Home tab, choose Format→Hide & Unhide→Hide Sheet.

Excel hides the worksheet from view.

3

To unhide the worksheet, choose Format→Hide & Unhide→Unhide Sheet.

The Unhide dialog box appears, listing all currently hidden worksheets in the active workbook.

4

Select the worksheet you want to unhide and click OK.

The worksheet appears in the workbook.

  • Add a Comment
  • Print
  • Share
blog comments powered by Disqus
Advertisement

Inside Dummies.com