View Menu

The View menu’s commands govern what view mode the windows are in, what toolbars are shown, and so on.

Normal

This is the standard Excel spreadsheet view.

Page Layout

Switches to Page Layout view. See the box on Data Entry.

Toolbox

All the various palettes below are part of the Toolbox—you can’t click this menu item directly.

Formatting Palette

Hides or shows the Formatting Palette.

Object Palette

Hides or shows the Object Palette.

Formula Builder

Hides or shows the Formula Builder.

Scrapbook

Hides or shows the Scrapbook.

Reference Tools

Hides or shows the Reference Tools.

Compatibility Report

Hides or shows the Compatibility Report.

Project Palette

Hides or shows the Project Palette.

Elements Gallery

Hides or shows the Elements Gallery.

Toolbars

Using this command’s submenu, you can hide or show Excel’s toolbars: Standard, Formatting, Border Drawing, Chart, Drawing, External Data, Forms, Formula Auditing, List, Movie, PivotTable, and Reviewing.

Customize Toolbars and Menus

Opens the Customize window, where you can select more toolbars or create your own (see Customizing Your Toolbars).

Ruler

(Page Layout view only.) Displays a ruler along the top of the Excel page.

Formula Bar

Hides or shows the formula bar. This is one that you should probably leave on, as you’ll be using the formula bar quite a bit.

Status Bar

Hides or shows the status bar at the bottom of an open workbook.

Header and Footer

Lets you edit the headers and footers that appear at the top and bottom of every page.

Comments

Shows all comments ...

Get Office 2008 for Macintosh: The Missing Manual now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.