Microsoft Office Tutorials and References
In Depth Information
Managing Worksheet Views
Managing Large Amounts of Data
Changing Worksheet Views
When working with a larger worksheet, it can
become difficult to see the entire worksheet on the
screen. As you scroll down or across the worksheet,
you may lose track of which column or row of data
you are entering. Excel contains several tools to help
you view your worksheet from different perspectives.
Normal: Choose View>Workbook Views>
Normal. Excel returns to the default Normal
view, which shows one continuous page of
columns and rows.
Page Break Preview: Choose View>
Workbook Views>Page Break Preview. A
Welcome to Page Break Preview dialog box
appears. Click OK. The Excel mode changes to
Page Break Preview, where Excel indicates
page breaks with lines (see Figure 11-16). You
can drag these lines to modify where pages
break. (See Chapter 12 for more on using
page breaks.) To return to the Normal view,
choose View>Workbook Views>Normal.
Page Layout: Choose View>Workbook
Views>Page Layout. As in Figure 11-15, the
Page Layout view displays your worksheets
on individual pages that correspond to
printed pages. A ruler appears on the top
and in the header and footer area. See
Chapter 12, “Setting Security and Printing
Options,” for more on headers and footers.
Page Break Preview.
Page Layout view with headers and footers.
Hide Message Box
If you do not want to see this dialog box
when you enter Page Break Preview, click Do
Not Show This Dialog Again.
Use Zoom Controls
Use the Zoom controls to increase or