Microsoft Office Tutorials and References
In Depth Information
Session 3.2
Header/Footer formatting buttons
Figure 3-32
Button
Name
Formatting Code
Action
Font
None
Sets font, text style, and font size
Page Number
&[Page]
Inserts page number
Total Pages
&[Pages]
Inserts total number of pages
Date
&[Date]
Inserts current date
Time
&[Time]
Inserts current time
File Path
&[Path]&[File]
Inserts path and filename
Filename
&[File]
Inserts filename
Tab Name
&[Tab]
Inserts name of active worksheet
Insert Picture
&[Picture]
Inserts an image file
Format Picture
None
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