Microsoft Office Tutorials and References
In Depth Information
Session 3.2
Header/Footer formatting buttons
Figure 3-32
Formatting Code
Sets font, text style, and font size
Page Number
Inserts page number
Total Pages
Inserts total number of pages
Inserts current date
Inserts current time
File Path
Inserts path and filename
Inserts filename
Tab Name
Inserts name of active worksheet
Insert Picture
Inserts an image file
Format Picture
Opens the Format Picture dialog box
Joan wants a header that displays the filename at the left margin and today’s date at the
right margin. She wants a footer that displays the name of the workbook author, with the
text aligned at the right margin of the footer. You’ll create the header and footer now.
To add a custom header and footer to the workbook:
1. Click the Setup button on the Print Preview toolbar, and then click the Header/Footer tab.
The Header/Footer dialog box opens.
2. Click the Custom Header button. The Header dialog box opens. See Figure 3-33.
Header dialog box
Figure 3-33
3. In the Left section box, type Filename: and then press the spacebar .
4. Click the Filename button to insert the format code. The formatting code for the name
of the file “&[File]” appears after the text that you entered.
5. Click the Right section box, and then click the Date button
. Excel inserts the &[Date]
format code into the section box.
6. Click the OK button to close the Header dialog box, and then click the Custom Footer but-
ton to open the Footer dialog box, which duplicates the layout of the Header dialog box.
Now you will create a footer that centers the page number and the total number of pages
at the bottom of the printout.
Search JabSto ::

Custom Search