How to Set the Default Font for Excel Headers and Footers
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.
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.
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.
Navigate to the 'Insert' tab on the ribbon and click on 'Header & Footer'. This will switch your workbook to the Page Layout view.
Click inside the header or footer section where your text is located, and highlight the text you want to format.
With the text highlighted, go to the 'Home' tab. Choose 'Arial' (or your preferred font), and adjust the font size or style as needed.

Prevent Header and Footer Font Scaling
Configure your page setup options to prevent the header and footer font size from shrinking when the worksheet is scaled for printing.
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. Open WPS Spreadsheet: Launch WPS Office and open your spreadsheet document.
- 2. Insert Header and Footer: Go to the 'Insert' tab and click on 'Header and Footer' to enter the editing mode.
- 3. Format the Text: Type your text, highlight it, and use the 'Home' tab to select your desired font and size.
- 4. Disable Scaling (Optional): Click 'Page Setup', navigate to the Header/Footer tab, and uncheck 'Scale with document' to keep font sizes fixed.

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.




