Microsoft Office Tutorials and References
In Depth Information
From Header to Footer
✓ Format Picture: Click this button to apply the formatting that you choose
from the Format Picture dialog box to the &[Picture] code that you
enter with the Insert Picture button without adding any code of its own.
To use these command buttons in the Header & Footer Elements group to
create a custom header or footer, follow these steps:
1. Put your worksheet into Page Layout view by clicking the Page Layout
View button on the Status bar or by clicking View ➪ Page Layout View
on the Ribbon or pressing Alt+WP.
In Page Layout view, the text Click to Add Header appears centered in
the top margin of the first page and the text Click to Add Footer appears
centered in the bottom margin.
2. Position the mouse pointer in the top margin to create a custom
header or the bottom margin to create a custom footer and then click
the pointer in the left, center, or right section of the header or footer
to set the insertion point and left-align, center, or right-align the text.
When Excel sets the insertion point, the text Click to Add Header and
Click to Add Footer disappears and the Design tab on the Header &
Footer Tools contextual tab becomes active on the Ribbon.
3. To add program-generated information to your custom header or
footer (such as the filename, worksheet name, current date, and so
forth), click the information’s corresponding command button in the
Header & Footer Elements group.
Excel inserts the appropriate header/footer code preceded by an
ampersand (&) into the header or footer. These codes are replaced by
the actual information (filename, worksheet name, graphic image, and
the like) as soon as you click another section of the header or footer or
finish the header or footer by clicking the mouse pointer outside of it.
4. (Optional) To add your own text to the custom header or footer, type
it at the insertion point.
When joining program-generated information indicated by a header/
footer code with your own text, be sure to insert the appropriate spaces
and punctuation. For example, to have Excel display Page 1 of 4 in a
custom header or footer, you do the following:
a. Type the word Page and press the spacebar.
Click the Page Number command button and press the spacebar again. b.
Type the word of and press the spacebar a third time.
Click the Number of Pages command button. d.
This inserts Page &[Page] of &[Pages] in the custom header (or footer).