Leading the way in Microsoft Office Development

Excel

This tab

There are commands on this tab to indicate or see if there are any hidden worksheets in the active workbook.

Intuitively you are looking for something like Sheets > Unhide.

The commands for hiding and showing worksheets are actualy on the Home tab under (Format > Unhide).

Workbook Views Group

Normal - Displays the worksheet in the normal view. There is also a shortcut to this view in the bottom right corner of the status bar.

Page Layout - (added in 2007). Displays the worksheet as it will appear on a printed page.Displays a very useful horizontal and vertical ruler plus you can add/change headers and footers, check margins, row/column headings and scaling options. Not to be confused with Print Preview. There is also a shortcut to this view in the bottom right corner of the status bar.

Page Break Preview - Used for adjusting page breaks. There is also a shortcut to this view in the bottom right corner of the status bar.

Custom Views - Displays the Custom Views dialog box.

Full Screen - Displays the workbook in full screen mode. Press Esc to return to the normal screen.

Show/Hide Group

Ruler - Toggles the display of the horizontal and vertical rulers. This is only available when you are in Page Layout view. By default the ruler displays the default units that are specified in the control panel, regional settings. These can be either inches, centimeters or millimeters.

Gridlines - Toggles the display of gridlines on the active worksheet. Provides a shortcut to (Excel Options)(Advanced tab, Display options for this worksheet).

Message Bar -

Formula Bar -

Headings -

Zoom Group

Zoom -

100% -

Zoom to Selection -

Window Group

New Window -

Arrange All -

Freeze Panes - Drop-Down.

Split-

Hide -

Unhide -

View Side by Side -

Synchronous Scrolling -

Reset Window Position -

Save Workspace -

Switch Windows - Drop-Down.

Macros Group

Macros - Button with Drop-Down.