Page 303 - Excel 2013 All-in-One For Dummies

Headers and Footers 285
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 lists and then entering 100 in the Scale text (or select 100 with its spinner buttons).
Using the Print buttons in the Sheet Options group
The Sheet Options group on the Ribbon’s Page Layout tab contains two very useful Print check boxes (neither of which is automatically selected). The first is in the Gridlines column and the second 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 head- ings 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 match as closely as possible their 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 needs editing.
Headers and Footers
Headers and footers are simply standard text that appears on every page of the report. A header is printed in the top margin of the page, and a footer is printed — you guessed it — in the bottom margin. Both are centered verti- cally in the margins. Unless you specify otherwise, Excel does not automati- cally 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 easiest way to add a header or footer to a report is to add it after put- ting the worksheet in Page Layout 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 displayed 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.
Book II Chapter 5
Printing Worksheets