Microsoft Office Tutorials and References
In Depth Information
Printing the Worksheet
Printing 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. A header is text and graphics that print at
the top of each page. Similarly, a footer is text and graphics that print at the bottom
of each page. 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 .
To Change the Worksheet’s Margins, Header,
and Orientation in Page Layout View
1 ENTER FORMULAS | 2 ENTER FUNCTIONS | 3 VERIFY FORMULAS
4 FORMAT WORKSHEET | 5 CHECK SPELLING | 6 PRINT WORKSHEET
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. Why? Often, you may want to
reduce margins so that the printed worksheet better ts the page. Changing the header helps to identify the content on
each page, and changing the orientation can help you t wider printouts across a sheet of paper. Margins are those
portions of a printed page outside the main body of the printed document and always are blank when printed.
The current worksheet is too wide for a single page and requires landscape orientation to t on one page in a
readable manner.
1
Tap or click the Page Layout button on the status bar to view the worksheet in Page Layout view (Figure 2 – 59).
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 pictures.
Page Layout view shows
how worksheet will look
in printed form
Page Layout
View button
Figure 2 – 59
 
Search JabSto ::




Custom Search