Microsoft Office Tutorials and References
In Depth Information
Managing Worksheet Views
Zoom using the Zoom slider, located at
the bottom-right corner of the Excel
window as shown in Figure 6-27. Drag
the slider to the left to zoom out, drag
to the right to zoom in. Zoom out by 10%
increments by clicking the minus button
to the left of the zoom slider; zoom in
by 10% increments by clicking the plus
button instead.
Using Page Layout
In Page Layout view, data is displayed as it might
look when printed, page by page. To switch to
Page Layout view, click the Page Layout button
on the View tab, or click the Page Layout view
button. In Page Layout view, the zoom is
automatically switched to 100%, and only the first
page appears, surrounded by the empty page
margins, as shown in Figure 6-28. To view the
next page of the printout, click either the
horizontal or vertical scroll bar (depending on the
layout of the worksheet).
Zoom
Button
Click to Zoom
Out by 10%
Zoom
Slider
Click to Zoom
In by 10%
Page headers and footers also appear. A header
is data that appears at the top of every page in
the printout, whereas a footer is data that prints
at the bottom of every page. Rulers appear so you
can adjust the size of the margins and header/
footer space as you like. Simply drag the margin
edge on the Ruler to adjust the margin size.
To create a header, click in any one of the three
boxes that make up the header (left, center, or
right) and type the data you want to appear
there. The Header & Footer Tools tab appears
with buttons for inserting special data such as
page number, the current date or time, or the
file name.
Figure 6-27
Zoom using the Zoom slider.
Click the Zoom button shown in Figure
6-27 to display the Zoom dialog box and
enter a zoom percentage.
Changing Worksheet Views
Excel has many preset views that are helpful
when working with any worksheet, but especially
large ones that contain lots of data. There are
four preset views: Normal, Page Layout, Page
Break Preview, and Full Screen. Each view serves
its own special purpose.
Using Page Break Preview
Page Break Preview is a special view designed to
show you where page breaks occur in a printout,
while allowing you the opportunity to adjust
them. To change to Page Break Preview, click the
Page Break Preview button on the View tab, or
click the Page Break Preview view button. If you
see a Welcome to Page Break Preview dialog box
reminding you that you can adjust page breaks
using this view, simply click OK to dismiss it.
Normal view is just that—normal. Data is
displayed in rows and columns clearly marked so
you can enter data easily. This is the view in
which you’ll do most of your work within Excel.
To change back to Normal view at any time, click
the Normal button on the View tab, or click the
Normal view button located just to the left of
the Zoom slider (refer to Figure 6-28).
 
Search JabSto ::




Custom Search