Fix Cut-Off Header and Footer Text in Excel
Question details
The user needs to make long header or footer text fit on printed Excel pages.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A user is preparing a worksheet for printing and reviewing its header or footer in Print Preview.
- Observed behavior
- Long header text is cut off in Print Preview when there is not enough room in its section.
Open the affected worksheet and select File > Print to identify which header or footer section is cut off. Note whether the text is in the left, center, or right section.
Edit the Header or Footer in Page Layout View
Use this method to adjust the text directly on the worksheet and check how it fits.
Select View > Page Layout to display the worksheet with its header and footer areas.
Click the header or footer section containing the cut-off text. Shorten the wording or move some text to another section.
Select the header or footer text and choose a smaller font size from the Home tab if it still does not fit.
Select File > Print and inspect Print Preview. Return to Page Layout view and adjust the text again if needed.

Adjust the Text in the Page Setup Dialog
Use Custom Header or Custom Footer to edit the left, center, and right sections in a dialog.
Adjust Spreadsheet Headers and Footers in WPS Office
Open your spreadsheet in WPS Office, edit the header or footer to make the text fit, and check the printed page before printing.
- 1. Open the spreadsheet: Open WPS Spreadsheet and select File > Open to choose your Excel workbook.
- 2. Edit the header or footer: Select Insert > Header & Footer, then click the section containing the text you want to change.
- 3. Make the text fit: Shorten the text, move part of it to another section, or select it and choose a smaller font size.
- 4. Preview the page: Open File > Print and check the preview. Return to the header or footer editor if the text still needs adjustment.

Frequently Asked Questions
Why is my Excel header text cut off in Print Preview?
The text may be too long for the available space in its header section. Try shortening it, moving some text to another section, or using a smaller font.
Where can I edit a footer in Excel?
Select View > Page Layout and click the footer area, or open the Page Setup dialog from the Page Layout tab and choose Header/Footer > Custom Footer.
How do I make header text smaller in Excel?
In View > Page Layout, select the header text and choose a smaller font size on the Home tab. You can also use the font formatting button in the Custom Header dialog.
How can I check whether the full header will print?
Select File > Print and inspect the page in Print Preview. If text is still cut off, return to the header editor and adjust it.




