Part I: Getting Started with Excel
Unfortunately, you can’t print the contents of a specific cell in a header or footer. For exam-
ple, you may want Excel to use the contents of cell A1 as part of a header. To do so, you
need to enter the cell’s contents manually—or write a VBA macro to perform this operation
before the sheet is printed.
Exploring other header and footer options
When a header or footer is selected in Page Layout view, the Header & Footer ➪ Design ➪
Options group contains controls that let you specify other options:
Different First Page If checked, you can specify a different header/footer for the first
printed page.
Different Odd & Even Pages If checked, you can specify a different header/footer for odd
and even pages.
Scale with Document If checked, the font size in the header and footer will be sized
accordingly if the document is scaled when printed. This option is enabled by default.
Align with Page Margins If checked, the left header and footer will be aligned with the
left margin, and the right header and footer will be aligned with the right margin. This
option is enabled by default.
If you check either of the Different First Page or Different Odd & Even Pages checkboxes, you can no longer use the
predefined headers and footers. You must use the Custom Header and Custom Footer buttons.
Exploring Other Print-Related Topics
The following sections cover some additional topics related to printing from Excel.
Copying Page Setup settings across sheets
Each Excel worksheet has its own print setup options (orientation, margins, headers and
footers, and so on). These options are specified in the Page Setup group of the Page Layout
tab.
When you add a new sheet to a workbook, it contains the default page setup settings.
Here’s an easy way to transfer the settings from one worksheet to additional worksheets:
- Activate the sheet that contains the desired setup information. This is the
source sheet.
- Select the target sheets, and Ctrl+click the sheet tabs of the sheets that you
want to update with the settings from the source sheet.
- Click the dialog box launcher in the lower-right corner of the Page Layout
➪ Page Setup group.
