Microsoft Office Tutorials and References
In Depth Information
From Header to Footer
After using the Width and Height Scale to Fit options, you may find that you
don’t want to scale the printing. Cancel scaling by selecting Automatic on both
the Width and Height drop-down menus and then entering 100 in the Scale
text box (or select 100% with its spinner buttons).
Using the Print buttons in
the Sheet Options group
The Sheet Options group contains two very useful Print check boxes (neither
of which is selected automatically). The first is in the Gridlines column and
the second is in the Headings column:
✓ Select the Print check box in the Gridlines column to print the column
and row gridlines on each page of the report.
✓ Select the Print check box in the Headings column to print the row
headings with the row numbers and the column headings with the column
letters on each page of the report.
Select both check boxes (by clicking them to put check marks in them) when
you want the printed version of your spreadsheet data to closely match its
onscreen appearance. This is useful when you need to use the cell references
on the printout to help you later locate the cells in the actual worksheet that
From Header to Footer
Headers and footers are simply standard text that appears on every page of the
report. A header prints in the top margin of the page, and a footer prints — you
guessed it — in the bottom margin. Both are centered vertically in the margins.
Unless you specify otherwise, Excel does not automatically add either a header
or footer to a new workbook.
Use headers and footers in a report to identify the document used to produce
the report and display the page numbers and the date and time of printing.
The place to add a header or footer to a report is in Page Layout view. You
can switch to this view by clicking the Page Layout View button on the Status
bar or by clicking the Page Layout View button on the Ribbon’s View tab, or
by just pressing Alt+WP.
When the worksheet is in Page Layout view, position the mouse pointer over
the section in the top margin of the first page marked Click to Add Header or
in the bottom margin of the first page marked Click to Add Footer.