On the Design tab, in the Header & Footer group, click the Header or Footer button, and select the built-in header or footer of your choosing.Īs an example, let's insert a footer that displays a page number and file name:.This will display the worksheet in Page Layout view and get the Design tab to appear. On the Insert tab, in the Text group, click Header & Footer.
Microsoft Excel comes equipped with a number of inbuilt headers and footers that can be inserted in your document in a mouse click.
#HOW TO HAVE DIFFERENT HEADERS IN WORD 2003 HOW TO#
How to add a preset header and footer in Excel When done, click anywhere in the worksheet to exit the footer area.įor example, to insert page numbers at the bottom of the worksheet, select one of the footer boxes and click Page Number on the Design tab, in the Header & Footer group.To add a preset footer, please follow these steps, to make a custom Excel footer, see these guidelines. Depending on the desired location, click the left, center, or right footer box, and type some text or insert the element you want.On the Design tab, click Go to Footer or scroll down to the footer boxes at the bottom of the page.On the Insert tab, in the Text group and click the Header & Footer button.Like an Excel header, a footer can also be inserted in a few easy steps: When you print out your worksheet, the header will be repeated on each page. To exit the header box without keeping the changes, press Esc.