Hiding and unhiding worksheets

As I mentioned previously, the Custom Views feature captures views for the entire workbook, including the hidden or visible status of each worksheet. First, let’s learn how to manually hide and unhide worksheets, which we’ll then automate with a Custom View.

You can easily hide any number of worksheets:

1. Open the example workbook for this chapter.
2. Select the January worksheet, hold down the Shift key, and click on the Table Feature worksheet.
3. Right-click any worksheet tab and then choose Hide (or choose Home | Format | Hide & Unhide | Hide Sheet).

At this point, only the Summary worksheet should be visible. Excel requires that you have at least one visible worksheet in each workbook.

Tip

If you want to hide an entire workbook but still keep it open in Excel, choose View | Hide. You can then choose View | Unhide to redisplay the workbook.

Historically, unhiding worksheets in Excel has been a tedious...