Microsoft Office Tutorials and References
In Depth Information
Session 3.2
Figure 3-31
Changing the page orientation
click to adjust
the size of the
worksheet
click to adjust
the worksheet
size to fit
within a given
number of
pages
3. Click the OK button to close the dialog box and return to the Print Preview window. The
preview of the printed worksheet in landscape orientation shows that the report will fit on a
single page.
The Page tab in the Page Setup dialog box contains other useful formatting features. You
can reduce or increase the size of the worksheet on the printed page. The default size is
100 percent. You can also have Excel automatically reduce the size of the report to fit
within a specified number of pages.
Working with Headers and Footers
Joan wants you to add a header and footer to the report. A header is text printed in the top
margin of every worksheet page. A footer is text printed at the bottom of every page.
Headers and footers can add important information to your printouts. For example, you
can create a header that displays your name and the date the report was created. If the
report covers multiple pages, you can use a footer to display the page number and the
total number of pages. You use the Page Setup dialog box to add headers and footers to a
worksheet.
Excel tries to anticipate headers and footers that you might want to include in your
worksheet. Clicking the Header or Footer list arrow displays a list of possible headers or
footers (the list is the same for both). For example, the “Page 1” entry inserts the page
number of the worksheet prefaced by the word “Page” in the header; the “Page 1 of ?” dis-
plays the page number and the total number of pages. Other entries in the list include the
name of the worksheet or workbook.
If you want to use a header or footer not available in the lists, you click the Custom
Header or Custom Footer button and create your own header and footer. The Header dia-
log box and the Footer dialog box are similar. Each dialog box is divided into three sec-
tions: left, center, and right. If you want to enter information such as the filename or the
date into the header or footer, you can either type the text or click one of the format but-
tons located above the three section boxes. Figure 3-32 describes the format buttons and
the corresponding format codes.
 
Search JabSto ::




Custom Search