Printing Problems

How to Fix Unexpected Text at the Bottom of Printed Excel Pages

Elise Williams Oct 7, 2026 869 views

Question details

The user needs to locate and remove unwanted text that is appearing at the bottom of printed Excel pages despite not being visible in the standard worksheet view or header/footer settings.

How to Fix Unexpected Text at the Bottom of Printed Excel Pages

Product: Microsoft Excel
Device & OS: not provided
Scenario: Printing an Excel spreadsheet to a physical printer or exporting it as a PDF.
Observed behavior: Unexpected text prints at the bottom of the page, bypassing visible cells and standard header/footer configurations.

Before you start

Before troubleshooting, switch your view to Page Break Preview (View tab > Page Break Preview) to get a clear visual representation of exactly what areas are being included in your final printout.

Solution 1Recommended

Inspect Hidden Rows, Objects, and Print Areas

Often, text is hidden in collapsed rows, transparent text boxes, or overly extended print areas that aren't immediately visible in the normal grid view.

Hidden elements like floating shapes, white text on white backgrounds, or collapsed rows will still render during the printing process if they fall within the defined print area.

Unhide rows and columns

Select the entire worksheet by clicking the triangle in the top-left corner, right-click any row number, and select 'Unhide' to reveal any hidden data at the bottom of your sheet.

Check for hidden objects

Press Ctrl+G to open the Go To dialog, click 'Special', select 'Objects', and click OK. This highlights any hidden shapes or text boxes that might contain the unwanted text. Press Delete to remove them.

Clear the Print Area

Navigate to the Page Layout tab, click 'Print Area' in the Page Setup group, and select 'Clear Print Area' to reset the printable boundaries to default.

Pro Tip: If you still cannot locate the text, try changing all font colors on the worksheet to black to reveal 'invisible' text that was accidentally colored white.

Solution 2

Clear Custom Headers, Footers, and Page Setup Margins

Residual text can sometimes be buried in custom footer settings or pushed down due to unusual margin setups.

Efficient Print Management

Easily Manage Print Settings with WPS Spreadsheet

WPS Office provides an intuitive Page Break Preview and highly visual print layout tools, making it exceptionally easy to spot and remove hidden text, rogue objects, or formatting errors before printing.

1. Open your file in WPS Spreadsheet: Launch WPS Office and open your workbook.
2. Switch to Page Layout view: Click on the 'View' tab and select 'Page Layout' to see exactly what will print, including all headers, footers, and margins.
3. Adjust Print Area visually: Highlight the specific cells you want to print, go to the 'Page Layout' tab, click 'Print Area', and choose 'Set Print Area' to explicitly define your output.
4. Preview and Print: Click 'Print Preview' to confirm the unexpected text is gone before sending the document to your printer.

Visual Page Break Preview to effortlessly spot hidden printable elements100% format compatibility with Microsoft Excel (.xlsx, .xls) filesClear, user-friendly interface for managing headers, footers, and print areasFree to download and lightweight on system resources

microsoft office alternative - wps office

Frequently Asked Questions

Why does text show up on print preview but not in the worksheet view?

This usually happens when text is placed inside a floating text box or shape that is set to 'Print object' but is positioned outside your normal viewing area, or if the text color matches the background (e.g., white text on a white background).

How do I remove a persistent page break in Excel?

Go to the Page Layout tab, click 'Breaks' in the Page Setup group, and select 'Reset All Page Breaks'. This will remove any manual breaks that are causing unexpected pagination and pushing text to the bottom.

Can a macro cause hidden text to print at the bottom of the page?

Yes, VBA macros can be programmed to dynamically add footers or text strings during the 'BeforePrint' event. You can check this by pressing Alt+F11 to open the VBA editor and reviewing the code inside the 'ThisWorkbook' module.

Document & File Issues