Hide and Unhide Excel Worksheets

3 Likes Comment

There may be times when you want to hide a particular excel worksheet so that it cannot be easily accessed. This is often done to protect information on a worksheet or to hide some unused sheet.
1. Click anywhere on the worksheet that you want to hide.
2. Choose Home➪Cells➪Format➪Hide & Unhide➪Hide Sheet. Excel hides the worksheet from view. All formula references to a hidden worksheet are still valid even when a worksheet is hidden. Optionally, right-click a worksheet tab and choose Hide (or Unhide).
3. To unhide the worksheet, choose Home➪Cells➪Format➪Hide & Unhide➪Unhide Sheet. A dialog box appears, listing all hidden worksheets in the active workbook.
4. Select the worksheet you want to unhide and then click OK.

You might like

About the Author:

Leave a Reply

Your email address will not be published. Required fields are marked *