Printing Problems

Fix Cut-Off Header and Footer Text in Excel

Emma BrownEmma Brown Nov 18, 2026 870 views

Question details

The user needs to make long header or footer text fit on printed Excel pages.

Fix Cut-Off Header and Footer Text in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Open Page Layout view

Select View > Page Layout to display the worksheet with its header and footer areas.

2
Edit the affected section

Click the header or footer section containing the cut-off text. Shorten the wording or move some text to another section.

3
Reduce the font size

Select the header or footer text and choose a smaller font size from the Home tab if it still does not fit.

4
Check the printed page

Select File > Print and inspect Print Preview. Return to Page Layout view and adjust the text again if needed.

Edit the Header or Footer in Page Layout View
Edit headers and footers in WPS

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. 1. Open the spreadsheet: Open WPS Spreadsheet and select File > Open to choose your Excel workbook.
  2. 2. Edit the header or footer: Select Insert > Header & Footer, then click the section containing the text you want to change.
  3. 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. 4. Preview the page: Open File > Print and check the preview. Return to the header or footer editor if the text still needs adjustment.
Adjust header and footer text before printingOpen and edit Microsoft Excel XLS and XLSX filesPreview the page layout before sending it to the printerUse a familiar spreadsheet interface
microsoft office alternative - wps office

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.