Microsoft Office Tutorials and References
In Depth Information
Preparing to Print the Worksheet
Preparing to Print the Worksheet
Excel allows for a great deal of customization in how a worksheet appears when printed.
For example, the margins on the page can be adjusted. A header or footer can be added to
each printed page as well. Excel also has the capability to work on the worksheet in Page
Layout view. Page Layout view allows you to create or modify a worksheet while viewing
how it will look in printed format. The default view that you have worked in up until this
point in the book is called Normal view .
Specify how the printed worksheet should appear.
Before printing a worksheet, you should consider how the worksheet will appear when
printed. In order to i t as much information on the printed page as possible, the margins
of the worksheet should be set to a reasonably small width and height. While the current
version of a worksheet may print on one page, you may add more data in the future that
causes the worksheet to extend to multiple pages. It is, therefore, a good idea to add a
page header to the worksheet that prints in the top margin of each page. A header is
common content that prints on every page of a worksheet. Landscape orientation is a good
choice for large worksheets because the printed worksheet’s width is greater than its length.
To Change the Worksheet’s Margins, Header, and Orientation in Page Layout View
The following steps change to Page Layout view, narrow the margins of the worksheet, change the header
of the worksheet, and set the orientation of the worksheet to landscape. Often, you may want to reduce margins so
that the printed worksheet better i ts the page. Margins are those portions of a printed page outside the main body
of the printed document and always are blank when printed. Recall that in Chapter 1, the worksheet was printed in
landscape orientation. The current worksheet also is too wide for a single page and requires landscape orientation
to i t on one page in a readable manner.
Click the Page
Layout button on
the status bar to
view the worksheet
in Page Layout view
(Figure 2 – 63).
Page Layout View shows how
worksheet will look in printed
What are some key
features of Page
Layout view?
Page Layout view
shows the worksheet
divided into pages.
A gray background
separates each page.
The white areas
surrounding each
page indicate the
print margins. The top
of each page includes
a Header area, and
the bottom of each page includes a Footer area. Page Layout view also includes a ruler
at the top of the page that assists you in placing objects on the page, such as charts and
Page Layout
View button
Figure 2 – 63
Search JabSto ::

Custom Search