Add predefined information to a header

You can make your workbook easier to read by adding worksheet names, pictures, dates, page numbers, and other things to your header. Excel has many of these predefined and ready for you to use, but you can also add your own text to a header.

  1. Click Insert > Header & Footer.

  2. Click the left, center, or right header box at the top of the page.

Left, right, and center header boxes

Tip:  To add predefined information to a footer so it will print at the bottom of every page, click Design > Go to Footer, and then click the left, center, or right footer box.

  1. Click Design, and then click one or more of the following elements to add them to your header.

Predefined header elements

Don’t worry if you see formulas rather than text or numbers in the header. For example, if you click Current Date, you’ll see &[Date], which is the formula Excel uses to insert the date. When you click outside of the header, the current date will be displayed.

Tip:  Use the formatting options on the Home tab to customize the header elements. For example, if you want your sheet name to stand out, increase its font size so it’s bigger than the other elements in the header.

Text formatting options

  1. When the headers are set up the way you want, click anywhere in the worksheet, and then click View > Normal.

Why can’t I see the header?

Click View > Page Layout. Headers and footers show up only in Page Layout view, Print Preview, and on printed pages.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×