Chapter 9: Printing Your Work
187
Button Code Function
File Path &[Path]&[File] Displays the workbook’s complete path and filename
File Name &[File] Displays the workbook name
Sheet Name &[Tab] Displays the sheet’s name
Picture Not applicable Enables you to add a picture
Format Picture Not applicable Enables you to change an added picture’s settingsYou can combine text and codes and insert as many codes as you like into each section.Note
If the text that you enter uses an ampersand (&), you must enter the ampersand twice (because Excel uses an
ampersand to signal a code). For example, to enter the text Research & Development into a section of a header
or footer, enter Research && Development. n
You can also use different fonts and sizes in your headers and footers. Just select the text that you
want to change and then use the formatting tools in the Home ➪ Font group. Or use the controls
on the Mini toolbar, which appears automatically when you select the text. If you don’t change the
font, Excel uses the font defined for the Normal style.Tip
You can use as many lines as you like. Press Enter to force a line break for multiline headers or footers. If you
use multiline headers or footers, you may need to adjust the top or bottom margin so the text won’t overlap
with the worksheet data. See “Adjusting the page margins,” earlier in this chapter. n
Unfortunately, you can’t print the contents of a specific cell in a header or footer. For example, 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 con-
tents manually — or write a VBA macro to perform this operation before the sheet is printed.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:l (^) Different First Page: If checked, you can specify a different header/footer for the first
printed page.
l (^) Different Odd & Even Pages: If checked, you can specify a different header/footer for
odd and even pages.
l (^) 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.
l (^) 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.