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 or get support in Communities.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.