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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access