Part I: Getting Started with Excel
58
To unhide a hidden worksheet, right-click any sheet tab and choose Unhide Sheet. Excel opens its
Unhide dialog box that lists all hidden sheets. Choose the sheet that you want to redisplay and
click OK. For reasons known only to a Microsoft programmer who is probably retired by now, you
can’t select multiple sheets from this dialog box, so you need to repeat the command for each sheet
that you want to unhide. When you unhide a sheet, it appears in its previous position among the
sheet tabs.Controlling the Worksheet View .........................................................................................
As you add more information to a worksheet, you may find that navigating and locating what you
want gets more difficult. Excel includes a few options that enable you to view your sheet, and
sometimes multiple sheets, more efficiently. This section discusses a few additional worksheet
options at your disposal.continuedAfter performing these steps, the worksheet is hidden and doesn’t appear in the Unhide dialog box.Caution
Be careful! After you make a sheet very hidden, you can’t use the Properties box to unhide it because you
aren’t able to select the sheet! To unhide such a sheet, press Alt+F11 to activate the Visual Basic Editor.
Locate the workbook in the Projects window and select the name of the sheet that is very hidden. Press F4
to display the Properties box, in which you can change the Visible property back to –1 - xlSheetVisible n