
When inserting an inbuilt header or footer in Excel, please be aware of the following caveats.

Two things you should know about preset headers and footers Voila, our Excel footer is created, and the following information will be printed at the bottom of each page: 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 delete a document in word 2018 how to
How to add a preset header and footer in Excel

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. When finished, click anywhere in the worksheet to leave the header area.If you wish the header to appear in the top left or top right corner of the page, click the left or right box and enter some information there. Now, you can type text, insert a picture, add a preset header or specific elements in any of the three Header boxes at the top of the page.This will switch the worksheet to Page Layout view.


To make your printed Excel documents look more stylish and professional, you can include a header or footer on each page of your worksheet. Do you want to know how to make a header in Excel? Or are you wondering how to add the footer page 1 to the current worksheet? This tutorial will teach you how to quickly insert one of the predefined headers and footers and how to create a custom one with your own text and graphics.
