MS Excel/View menu
Overview File Menu Edit Menu View Menu Insert Menu
Format Menu Tools Menu Data Menu Window Menu Help Menu

A view is a set of display and print settings you can name and apply to a workbook. You can create more than one view of the same workbook without saving each view separately. In Excel there are only two views compared to five in Word. Here are the choices


This is the default option for the view. As you enter data into the worksheet, you can stay in this view mode. The only thing you see in this view option are the columns and the rows that make up the worksheet.

Page Break View

This view splits the worksheet into printable areas. When you want to print part of the worksheet, you should use this view option

Bitmap Image

Instead of more view options, there are more toolbars in Excel. In order to access these toolbars, you can do the following

View Toolbars

For example the drawing toolbar opens up new options towards the bottom of the worksheet

Bitmap Image

In addition to the toolbars, there are two more options

View Formula Bar

This opens a new window where you can enter different formulas

View Status Bar

This opens a window in the bottom to show the status of the worksheet.

View Header and Footer

Bitmap Image

View Zoom

Bitmap Image