Format text in headers or footers

You can change the font, style or size of headers or footers you want to print with your data. You can also make sure the header and footer font size settings don't change when you scale the worksheet for printing.

  1. Open the worksheet that has the header or footer text you want to format.

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

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

    Page Layout button on the status bar

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

  4. On the Home tab in the Font group, pick the formatting options you want.

    Font group on the Home tab

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

    Normal view button on the status bar

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

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

  2. Click Design and uncheck the Scale with Document box.

    the scale with document option on the Design tab

    Tip: If you leave the Scale with Document box checked, the header and footer font will scale with the worksheet, making the header and footer text smaller when you print with the Fit Sheet on One Page scaling option selected.

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

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!

×