Printing Problems

How to Fix an Excel Spreadsheet That Stops Printing After One Page

Elise Williams Oct 19, 2026 868 views

Question details

The user needs to print a multi-page spreadsheet, but the printer stops after producing only the first page.

Product: Excel
Device & OS: not provided
Scenario: Attempting to print a workbook that contains multiple pages of data.
Observed behavior: The printing process terminates prematurely after a single page is printed, ignoring the rest of the worksheet data.

Before you start

Verify that your printer has enough paper and ink, and ensure there are no stuck documents in the print queue before modifying your spreadsheet settings.

Solution 1Recommended

Clear and Reset the Print Area

Clearing the print area ensures that Excel is not artificially restricted to printing just a single highlighted section of your worksheet.

A predefined print area limits the printer output to specific cells. If it was accidentally set to encompass only enough data for one page, the rest of your workbook will be ignored during printing.

Open Page Layout

Navigate to the Page Layout tab on the Excel ribbon.

Clear existing print area

Click on 'Print Area' in the Page Setup group, then select 'Clear Print Area' from the drop-down menu.

Set a new print area (optional)

If you still want to define specific boundaries, highlight all the cells you intend to print, click 'Print Area', and select 'Set Print Area'.

Page Break Preview: Use the Page Break Preview under the View tab to visually confirm what data falls on each printed page.

Solution 2

Adjust Page Scaling Settings

Disabling the 'Fit to 1 page' scaling option ensures your data is allowed to flow naturally across multiple pages.

Solution 3

Copy Worksheet Data to a New Workbook

Transferring your data into a fresh file can resolve underlying file corruption or persistent formatting glitches that block multi-page printing.

Efficient Spreadsheet Printing

Easily Manage and Print Spreadsheets with WPS Office

WPS Spreadsheet features an intuitive Page Layout interface and an interactive Print Preview, making it incredibly easy to set print areas, adjust page scaling, and flawlessly print multi-page workbooks without formatting errors.

1. Open your file: Launch WPS Spreadsheet and open your multi-page Excel document.
2. Adjust the print area: Navigate to the Page Layout tab and use the Print Area tool to clear or define your exact printing boundaries.
3. Verify page breaks: Click the View tab and select Page Break Preview to quickly drag and adjust the blue lines separating your pages.
4. Print successfully: Press Ctrl + P to open the Print dialog, review the multi-page preview, and click Print.

Free and lightweight alternative for powerful spreadsheet managementFully compatible with Microsoft Excel (.xlsx, .xls) files and formattingIntuitive Page Break Preview to visually adjust multi-page printingBuilt-in PDF converter to easily save and print precise layouts

Frequently Asked Questions

Why is my Excel print preview only showing one page?

Your print preview will only display one page if a specific print area was accidentally configured for just a small cluster of cells, or if the page scaling is set to 'Fit to 1 page'. Check your Page Layout settings to clear the print area and restore scaling to 100%.

Can hidden rows or columns prevent my Excel sheet from printing completely?

Yes. If the bulk of your remaining data is located within hidden rows or columns, it will not be sent to the printer. You can unhide them by selecting the entire sheet, navigating to Home > Format > Hide & Unhide, and choosing to unhide the rows and columns.

How do I print an Excel sheet on multiple pages without cutting off columns?

To fit all columns on one page but allow rows to span multiple pages, go to Page Layout > Page Setup. Under the Scaling section, select 'Fit to', type '1' page wide, and delete the number in the 'tall' box to leave it blank. This forces columns to fit while letting the rows print naturally over several pages.

Document & File Issues