Remove an Excel Footer and Reclaim Printed Page Space
Question details
Remove the footer and reclaim vertical space so a worksheet can fit on one printed page.

- 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.
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.
Remove the Footer and Reduce the Bottom Margin in Excel
Use Page Setup to clear the footer and make more room for worksheet content.
Select the worksheet, open the Page Layout tab, and click the small dialog launcher in the Page Setup group.
On the Header/Footer tab, set Footer to (none).
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.
Click OK, then open File > Print and review the page preview. Adjust the margins again if needed.

Fit the Excel Worksheet on One Printed Page
Use print scaling if removing the footer and reducing margins do not fit the worksheet on one page.
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. Open the workbook: Launch WPS Spreadsheets and use Open to select your Excel workbook.
- 2. Remove the footer: Select the worksheet, open Page Layout > Page Setup, and set the footer to None on the Header/Footer tab.
- 3. Reduce the bottom margin: In Page Setup, open the Margins tab and reduce the bottom margin within your printer's supported limits.
- 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.

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.




