Lesson 84: How to use Header and Footer in Excel

This article shows you how to add information to the header (header of each printed page – Header) or footer (bottom of each printed page – Footer) in Excel.

How to use Header and Footer in Excel

1. On the View tab, in the Workbook Views group, click Page Layout, to switch to Page Layout view.

2. Click Add header.

3. On the Design tab, in the Header & Footer Elements group, click Current Date to add the current date (or add the current time, file name, sheet name, etc.).

Result:

4. You can also add information to the left and right parts of the Header. For example, click the section on the left to add your company name.

5. Click somewhere else on the sheet to see the title.

In addition, you can also view many other excel articles here.