How to Stop Excel from Shrinking Content to the First Printed Page
Question details
The user wants to prevent Excel from automatically shrinking multi-page invoice content to fit onto a single printed page.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Printing a multi-page worksheet or invoice layout.
- Observed behavior
- Excel resizes and repositions the content, forcing it all onto the first printed page instead of maintaining the intended multi-page layout.
Before adjusting your print settings, ensure your printer drivers are up to date and that you have selected the correct paper size for your invoice.
Change Scale to Fit Settings to Automatic
The most common reason Excel shrinks content to one page is that the 'Scale to Fit' option is forcing it. Changing this to Automatic resolves the issue.
Excel has a built-in feature designed to save paper by compressing your data to fit on fewer pages. If this is accidentally triggered, it will shrink your entire invoice to fit on page one.
Open your workbook and click on the 'Page Layout' tab located on the top ribbon.
Find the 'Scale to Fit' group within the Page Layout ribbon.
Click the drop-down menus next to 'Width' and 'Height', and change both settings from '1 page' to 'Automatic'.

Reset the Print Area and Page Breaks
Incorrectly defined print areas or manual page breaks can also cause severe layout issues during printing.
Use WPS Spreadsheet for Hassle-Free Printing
WPS Office provides an intuitive Page Layout and Print Preview interface, making it incredibly easy to manage multi-page invoices and complex worksheets without unexpected scaling issues.
- 1. Open your file in WPS: Launch WPS Spreadsheet and open your invoice or worksheet.
- 2. Access Page Layout: Click on the 'Page Layout' tab to view your scaling and print area options.
- 3. Adjust Print Settings: Ensure 'Width' and 'Height' are set to 'Automatic' to prevent unwanted shrinking.
- 4. Preview and Print: Click 'Print Preview' to confirm the layout across multiple pages, then hit 'Print'.

Frequently Asked Questions
Why does my Excel spreadsheet print so small?
This usually happens because the 'Scale to Fit' settings are configured to fit the entire worksheet onto one page. Changing the Width and Height settings to 'Automatic' in the Page Layout tab will restore the normal 100% print size.
How do I force Excel to print on multiple pages?
Ensure your scaling is set to 100% or 'Automatic' for both width and height. You can also manually insert page breaks by going to Page Layout > Breaks > Insert Page Break at your desired rows or columns to split the content perfectly.
Will changing the paper size fix my printing layout?
It might help if the wrong paper size was selected originally. Go to Page Layout > Size and ensure it matches the physical paper in your printer (e.g., Letter or A4). However, if your scaling is forced to '1 page', changing the paper size alone won't stop the content from shrinking.




