Printing Problems

How to Fix Excel Printing an Invisible Row on a Second Page

Kushani NimanthikaKushani Nimanthika Nov 2, 2026 869 views

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.

How to Fix Excel Printing an Invisible Row on a Second 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 you start

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.

Solution 1Recommended

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.

1
Access Page Setup

Navigate to the 'Page Layout' tab on the top ribbon and click on 'Print Titles' in the Page Setup group.

2
Check repeating rows

In the Page Setup dialog box, look at the 'Sheet' tab. Check the field labeled 'Rows to repeat at top'.

3
Clear the unwanted title

If there is a cell reference in that field that corresponds to the invisible row, delete it to clear the setting.

4
Reset the print area

While in the same dialog box, delete any data in the 'Print area' box to reset it, then click 'OK' to save your changes.

Clear Repeating Print Titles and Reset Print Area
Check Print Preview: Press Ctrl + P to open the Print Preview and confirm that the document now perfectly fits onto a single page without the extra row.
Easy Print Management

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. 1. Open your spreadsheet: Launch WPS Spreadsheet and open the invoice or document causing the printing issue.
  2. 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. 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. 4. Preview and Print: Click 'Print Preview' to confirm your document fits on exactly one page, then print with confidence.
Clear visual indicators for print areas and page breaks to avoid extra printed pages.Fully compatible with Microsoft Excel (.xlsx, .xls) files and their complex print settings.Lightweight, fast, and free to use for everyday office tasks.
microsoft office alternative - wps office

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.