Microsoft Office Tutorials and References
In Depth Information
Adding headers and footers to printed pages
In this exercise, you’ll create a custom header for a workbook. You’ll then add a graphic to
the footer and edit the graphic by using the Format Picture dialog box.
SET UP You need the RevenueByCustomer workbook and the ConsolidatedMessenger
image located in your Chapter11 practice file folder to complete this exercise. Open the
workbook, and then follow the steps.
On the Insert tab, click the Tex t button, and then click Header & Footer to display
your workbook in Page Layout view.
In the middle header section, enter Q1 2013 , and then press Enter .
On the Design tool tab, in the Header & Footer Elements group, click File Name to
add the &[File] code to the header.
To the right of the &[File] code, enter a comma, and then press the Spacebar .
On the Design tool tab, in the Header & Footer Elements group, click Current Date .
Excel changes the contents of the middle header section to &[File], &[Date] .