How to Fix Excel Printing an Invisible Row on a Second Page
Question details
The user needs to prevent an invisible row from printing on an unwanted second page when the main invoice appears to fit on a single page.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Printing a completed worksheet or invoice that is visually formatted to fit entirely on one page.
- Observed behavior
- Excel produces a second printed page containing a row with data, such as date, rate, and subtotal, even though this row is not visible on the main worksheet interface.
Before making changes, switch your Excel view to 'Page Layout' or use 'Print Preview' to see exactly how your document is currently paginated and identify where the extra row is originating.
Clear Repeating Print Titles and Reset Print Area
The extra row may be configured as a repeating print title, which forces it to appear at the top or bottom of every printed page regardless of its visibility in the normal view.
Excel allows users to set specific rows to repeat on every printed page, which is useful for headers. If a hidden row containing subtotals or rates is accidentally set as a repeating title, it will automatically generate a second page when printed.
Navigate to the 'Page Layout' tab on the top ribbon and click on 'Print Titles' in the Page Setup group.
In the Page Setup dialog box, look at the 'Sheet' tab. Check the field labeled 'Rows to repeat at top'.
If there is a cell reference in that field that corresponds to the invisible row, delete it to clear the setting.
While in the same dialog box, delete any data in the 'Print area' box to reset it, then click 'OK' to save your changes.

Unhide Rows and Adjust Worksheet Data
The row might be physically hidden within the spreadsheet but is still being captured by Excel's active print area.
Easily Manage Print Settings with WPS Office
WPS Office provides an intuitive Page Layout interface and an easy-to-use Print Preview feature, allowing you to quickly spot and fix hidden rows, repeating headers, and print areas before wasting paper.
- 1. Open your spreadsheet: Launch WPS Spreadsheet and open the invoice or document causing the printing issue.
- 2. Manage Print Area: Go to the 'Page Layout' tab and click 'Print Area' to easily set, clear, or review the exact printing boundaries of your sheet.
- 3. Check Print Titles: Click the 'Print Titles' button to quickly identify and remove any hidden rows accidentally set to repeat on printed pages.
- 4. Preview and Print: Click 'Print Preview' to confirm your document fits on exactly one page, then print with confidence.

Frequently Asked Questions
Why does Excel print an extra blank page at the end of my document?
This usually happens if the active print area extends beyond your actual data, or if there are invisible formatting characters (like spaces or borders) in otherwise empty cells. You can fix this by manually setting the print area or deleting the extra blank columns and rows.
How do I force my Excel sheet to print on exactly one page?
You can use the 'Fit to' feature. Go to the Page Layout tab, click the dialog box launcher for Page Setup, select 'Fit to', and set it to 1 page wide by 1 page tall.
Does Excel normally print hidden rows and columns?
By default, Excel ignores hidden rows and columns when printing standard data. However, if a hidden row is specifically set as a repeating print title under Page Setup, it may still be forced onto the printed page.




