Microsoft Office Tutorials and References
In Depth Information
Adding Headers and Footers
To add a custom header or footer, select the
Page Layout view and follow these steps:
1. Click in the area of the header or footer
where you would like the custom text to
be aligned on the page. Excel adds a new
Header & Footer Tools Design tab.
2. Choose Header & Footer Tools Design >
Header & Footer Elements and select any
combination of the elements you want to see
on your printed document. Excel inserts the
code associated with the element, as shown
in Figure 9-24. Alternatively, you can type
directly into the header or footer area.
Figure 9-23
Predefined header and footer options.
Table 9-3 Header and Footer Tools
Button
Code
Description
Page Number
&[Page]
Inserts the current page number
Number of Pages
&[Pages]
Inserts the total number of pages that will be printed
Current Date
&[Date]
Inserts the current date
Current Time
&[Time]
Inserts the current time
File Path
&[Path]&[File]
Inserts the complete path, including file name, for this workbook
File Name
&[File]
Inserts the file name for this workbook
Sheet Name
&[Tab]
Inserts the name of the worksheet as displayed on the sheet tab
Picture
&[Picture]
Enables you to insert a picture; also used for watermarks, as
described in the next section
Format Picture
Displays the Format Picture dialog box to adjust the size and
scale of the picture
 
Search JabSto ::




Custom Search