Printing Problems

Remove an Excel Footer and Reclaim Printed Page Space

John WilsonJohn Wilson Nov 18, 2026 868 views

Question details

Remove the footer and reclaim vertical space so a worksheet can fit on one printed page.

Remove an Excel Footer and Reclaim Printed Page Space
Product
Microsoft Excel
Device & OS
not provided
Scenario
A worksheet needs to fit on one printed page without reserving unnecessary space at the bottom.
Observed behavior
Removing footer text alone may leave the worksheet's bottom print margin unchanged.
Before you start

Open the worksheet and check File > Print to see how many pages it currently uses. Confirm the paper size and printer, since printers can have different minimum margins.

Solution 1Recommended

Remove the Footer and Reduce the Bottom Margin in Excel

Use Page Setup to clear the footer and make more room for worksheet content.

1
Open Page Setup

Select the worksheet, open the Page Layout tab, and click the small dialog launcher in the Page Setup group.

2
Remove the footer

On the Header/Footer tab, set Footer to (none).

3
Adjust the margins

Open the Margins tab and reduce the Bottom margin. You can also reduce the Footer margin, but the Bottom margin is what controls the space available for worksheet content.

4
Check the result

Click OK, then open File > Print and review the page preview. Adjust the margins again if needed.

Remove the Footer and Reduce the Bottom Margin in Excel
Printer limits: Some printers cannot print to the edge of the paper. If Excel or the printer warns that a margin is too small, increase it to a supported value.
Print worksheets with WPS

Remove a Worksheet Footer and Adjust Print Margins in WPS Spreadsheets

Open the workbook in WPS Spreadsheets, remove the footer, and adjust page margins and scaling to fit the worksheet for printing.

  1. 1. Open the workbook: Launch WPS Spreadsheets and use Open to select your Excel workbook.
  2. 2. Remove the footer: Select the worksheet, open Page Layout > Page Setup, and set the footer to None on the Header/Footer tab.
  3. 3. Reduce the bottom margin: In Page Setup, open the Margins tab and reduce the bottom margin within your printer's supported limits.
  4. 4. Preview and scale: Open File > Print to review the result. If necessary, use the print scaling settings to fit the sheet on one page.
Remove worksheet footers and adjust print marginsOpen and edit Microsoft Excel XLSX and XLS filesPreview and scale worksheets before printingUse a familiar spreadsheet interface
microsoft office alternative - wps office

Frequently Asked Questions

Why is there still space below my worksheet after I delete the footer?

Deleting footer text does not automatically change the bottom margin. Open Page Layout > Page Setup > Margins and reduce the Bottom setting.

Can I set the bottom margin to zero?

You can try entering zero under Page Layout > Page Setup > Margins, but your printer may require a minimum margin. Check File > Print and increase the margin if a warning appears.

How do I fit a worksheet on one page without changing the footer?

Open File > Print and select Fit Sheet on One Page from the scaling menu. Check the preview because this can make the content smaller.

Does changing the footer margin increase the space for worksheet cells?

The footer margin controls the footer's position. To increase the space available for worksheet content, reduce the Bottom margin in the Margins tab.