Office Settings & Configuration

How to Set the Default Font for Excel Headers and Footers

Bushra ParveenBushra Parveen Oct 28, 2026 869 views

Question details

The user wants to change the default font used in Excel headers and footers so that it matches the font used in the rest of the worksheet.

Product
Excel
Device & OS
not provided
Scenario
Customizing the page layout for printing by standardizing the header and footer text format.
Observed behavior
Headers and footers default to Times New Roman, even when the primary worksheet document is set to use Arial.
Before you start

Ensure your worksheet is open and switch to the Page Layout view so you can easily see changes applied to your headers and footers in real time.

Solution 1Recommended

Format Text Directly in the Header or Footer

Manually change the font of your header or footer by selecting the text and applying new font settings from the Home tab.

Excel headers and footers maintain their own formatting separate from the main worksheet cells. To change the font, you must format the text directly within the header or footer section.

1
Access the Header & Footer View

Navigate to the 'Insert' tab on the ribbon and click on 'Header & Footer'. This will switch your workbook to the Page Layout view.

2
Select the Text

Click inside the header or footer section where your text is located, and highlight the text you want to format.

3
Change the Font

With the text highlighted, go to the 'Home' tab. Choose 'Arial' (or your preferred font), and adjust the font size or style as needed.

Format Text Directly in the Header or Footer
Tip: To apply this default formatting to all new sheets, you can save a blank workbook with these header and footer settings as an Excel Template (.xltx) in your XLSTART folder.
Easy Spreadsheet Formatting

Easily Format Headers and Footers with WPS Office

WPS Spreadsheet provides an intuitive interface for customizing headers, footers, and page layouts. You can seamlessly match your fonts and ensure your printed documents look highly professional.

  1. 1. Open WPS Spreadsheet: Launch WPS Office and open your spreadsheet document.
  2. 2. Insert Header and Footer: Go to the 'Insert' tab and click on 'Header and Footer' to enter the editing mode.
  3. 3. Format the Text: Type your text, highlight it, and use the 'Home' tab to select your desired font and size.
  4. 4. Disable Scaling (Optional): Click 'Page Setup', navigate to the Header/Footer tab, and uncheck 'Scale with document' to keep font sizes fixed.
Directly edit and format header and footer fonts with a user-friendly interfaceSeamless compatibility with all Microsoft Excel (.xlsx and .xls) formatsLightweight, fast, and easy to navigate for everyday spreadsheet tasksFree to use with comprehensive page setup and printing controls
microsoft office alternative - wps office

Frequently Asked Questions

Can I set a global default font for all future Excel headers and footers?

Excel does not have a standard options menu to globally change the default header and footer font for all future files. However, you can create a blank workbook, apply your desired header/footer font settings, and save it as a template (Book.xltx) in your XLSTART folder.

Why does my header font shrink when I print my worksheet?

This occurs because the 'Scale with document' option is enabled by default. To fix this, click inside your header, go to the Header & Footer tab on the ribbon, and uncheck 'Scale with document' in the Options group.

Can I use different fonts for the header and the footer?

Yes. Headers and footers are separate elements. You can highlight the text in the header to apply one font from the Home tab, and then highlight the text in the footer to apply a completely different font or size.