In Microsoft Excel, you can insert headers and footers to add information to the top or bottom of each page in your worksheet. In this lesson you can learn how to insert header and footer to your spreadsheet. You may need it when you are printing spreadsheet.
When you are printing data from Excel the Header and Footer option is really useful. This gives you the possibility of marking pages in a document without having to manually enter text on each page. In this way, for example, you can automatically insert a page number, document name, author name, and many other useful information. By using this option, you make your spreadsheet more professional.
To insert Header and Footer go to the Ribbon. Select the Insert tab. Go to Text section and click Header & Footer.
Insert header and footer
After clicking Design a contextual tab appears. You can choose the content which you will insert to the Header and Footer. You may also notice that the program automatically divides the sheet into the page (looks a bit like a print preview).
The tab is divided into four sections:
- Header and Footer - buttons allow you to insert a ready-made system headers and footers.
- Header and Footer Elements - the individual elements that can be inserted anywhere in the header or footer:
- Page Number - inserts the current page number of the document,
- Number of Pages - inserts the total number of pages in the sheet,
- Current Date - inserts the current date (it will change from day to day),
- Current Time - inserts the current time (also changes),
- File Path - inserts the file path on the disk,
- File Name - insert the name of the file that contains the given sheet
- Sheet Name - insert the name of the current sheet
- Image - insert any graphics from the disk (eg, logo, symbol, etc.).
- Different First Page - select this option and the items added to the header or footer on the first page will be different from the other pages of the document,
- Different Odd & Even Pages - headers and footers are divided into two types (for odd and even pages). Changes made on either side will change them in all odd-numbered pages. The same way in the even-numbered pages,
- Scaling with Document - the option is applicable only for scaling the size of the document to print
- Align with Page Margins - setting the edge of the header and footer to the left and right margin of the page.
To return to the previous sheet view on the View tab in the Workbook Views group, click Normal.
These are the basic steps for inserting headers and footers in Excel. By following these steps, you can easily add important information to the top or bottom of each page in your worksheet.
Further reading: How to copy only unique records? Define Name