PDF Conversion Issues

How to Fix Excel Worksheet Saving as Two PDF Pages

Steve K Oct 22, 2026 869 views

Question details

Users need to resolve an issue where an Excel spreadsheet splits into two pages instead of staying on a single page during PDF conversion.

How to Fix an Excel Worksheet Saving as Two PDF Pages

Product: Excel
Device & OS: not provided
Scenario: Exporting, printing, or saving a worksheet to a PDF format.
Observed behavior: A spreadsheet that appears to fit on a single screen or page exports as a two-page PDF, often with a blank second page or a few overspilling columns.

Before you start

Before adjusting any settings, switch to the Page Layout view or open Print Preview to visually identify exactly which columns or rows are spilling over onto the second page.

Solution 1Recommended

Use the 'Fit Sheet on One Page' Scaling Option

The quickest way to force your Excel worksheet onto a single PDF page is by utilizing the built-in page scaling settings.

Excel has automatic scaling options designed specifically to shrink your data to fit perfectly onto a set number of printed or exported pages.

Open Print Settings

Navigate to the 'File' tab in the top ribbon and select 'Print' to open the print preview window.

Access Scaling Options

Scroll down to the bottom of the Settings section and click on the Scaling drop-down menu, which is often set to 'No Scaling' by default.

Apply Fit to One Page

Select 'Fit Sheet on One Page' from the menu. The preview will update to show all your data on a single page.

Export to PDF

Click 'Save As' or use the 'Microsoft Print to PDF' printer to export your file with the new scaling applied.

Check Readability: Scaling forces all columns and rows to shrink. If you have a massive dataset, the text may become too small to read comfortably.

Solution 2

Define a Precise Print Area and Adjust Margins

Sometimes invisible formatting or excessively wide margins cause the PDF to spill over. Defining the exact export area and narrowing margins provides more space for data.

Solution 3

Change Page Orientation to Landscape

If your spreadsheet is wider than it is tall, simply rotating the page layout can prevent columns from breaking onto a second page.

Seamless PDF Conversion

Easily Convert Excel Worksheets to a Single PDF Page with WPS Office

WPS Spreadsheet provides an intuitive 'Export to PDF' feature with built-in preview and layout adjustments. It ensures your spreadsheets fit perfectly onto a single page without frustrating formatting issues.

1. Open Your Spreadsheet: Launch WPS Office and open your Excel workbook.
2. Select Export to PDF: Click on the 'Menu' button in the top left corner, then select 'Export to PDF'.
3. Adjust Page Setup: In the export dialogue box, click on the 'Page Setup' or 'Layout' options.
4. Apply One-Page Scaling: Under the scaling options, select 'Fit sheet on one page' to guarantee no data spills over.
5. Export the File: Click 'Export' to immediately save your perfectly formatted one-page PDF to your device.

Fully compatible with Microsoft Excel (.xlsx, .xls) files.One-click 'Export to PDF' tool with clear, built-in layout previews.Easily adjust scaling, margins, and print areas directly from the export window.A free, lightweight, and easy-to-use alternative to Microsoft Office.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel to PDF conversion include a completely blank second page?

This usually happens when invisible formatting, errant spaces, or borders extend beyond your actual data into a neighboring cell. Setting a specific Print Area limits the PDF strictly to the cells you highlight, eliminating the blank page.

Can I fit all columns on one page but let rows span multiple pages?

Yes. In the Print Settings or Page Setup menu, choose 'Fit All Columns on One Page' instead of fitting the entire sheet. This keeps the width constrained to a single page while allowing long lists of rows to break naturally onto subsequent pages.

How do I see where the page will split before exporting to PDF?

You can use the 'Page Break Preview' tool. Go to the 'View' tab and select 'Page Break Preview'. This view displays blue lines indicating exactly where the pages will cut off. You can click and drag these blue lines to manually adjust what fits on page one.

PDF Troubleshooting