Microsoft Office Tutorials and References
In Depth Information
Adding Headers and Footers
Adding Headers and Footers
Adding a header or footer to a workbook is a convenient way to make your printout easier
for readers to follow. Using the Design tab under Header & Footer Tools, you can add
predefined header or footer information—such as a page number and worksheet title—at
the top and bottom of each page or section of a worksheet or workbook. If a predefined
header or footer doesn’t work, you can insert individual elements such as your computer
system’s date and time, the name of the workbook and sheet, a picture, or other custom
information. When you insert elements in a header or footer, Excel inserts an ampersand
followed by brackets with the name of the element, such as &[Page] for Page Number.
Excel changes the code to the actual element when you exit headers or footers. Instead of
having the same header or footer on every page, you can select options on the Design tab
to create a different first page, or different odd and even pages.
Add a Predefined Header or Footer in Page Layout View
Click the Insert tab.
Click the Header & Footer button.
The worksheet appears in Page Layout view.
To insert predefined header and footer information, click the Header or Footer
button, and then click the information you want.
A sample of the information appears on the menu. After you make a selection,
Excel exits the Design tab.
To add more header or footer text, click the left, center, or right header or foot-
er boxes at the top or at the bottom of the worksheet page where you want to
add text to place the insertion point.
To change a header or footer, select the current text.
Search JabSto ::




Custom Search