Office
Sign in

Format text in headers or footers

You can change the font, style, and size of the headers and footers that you want to print with along with contents of your worksheet. Also, there are options you can configure to ensure that the header and footer font size settings don't change when you scale the worksheet for printing.

Follow these steps to format header / footer text:

  1. Ensure that either a header or a footer (or both) have been added to the worksheet.

  2. Open the worksheet containing the header or footer text you want to format.

    Note: If you don't have a header or footer, add them by clicking Insert > Header & Footer.

  3. On the status bar, click the Page Layout View button.

    Page Layout button on the status bar

  4. Select the header or footer text you want to change.

  5. On the Home tab in the Font group, set the formatting options that you want to apply to the header / footer.

    Font group on the Home tab

  6. When you're done, click the Normal view button on the status bar.

Prevent the header and footer font size from changing when you scale the worksheet for printing

If you don't want the header and footer to scale with the document:

  • On the status bar, click the Page Layout View button, and then click Design and uncheck the Scale with Document box.

    the scale with document option on the Design tab

Tip: If you leave a check in the Scale with Document box, the header and footer font will scale along with the worksheet—and your header/footer Font settings likely won't be reflected in the printout view.

For more information about working with titles, dates, and page numbers in headers and footers, see Headers and footers in a worksheet.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×