Printing Problems

How to Stop Excel from Shrinking Content to the First Printed Page

Khadija KhanKhadija Khan Nov 10, 2026 868 views

Question details

The user wants to prevent Excel from automatically shrinking multi-page invoice content to fit onto a single printed page.

How to Stop Excel from Shrinking Content to the First 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 you start

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.

Solution 1Recommended

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.

1
Navigate to Page Layout

Open your workbook and click on the 'Page Layout' tab located on the top ribbon.

2
Locate Scale to Fit

Find the 'Scale to Fit' group within the Page Layout ribbon.

3
Adjust Width and Height

Click the drop-down menus next to 'Width' and 'Height', and change both settings from '1 page' to 'Automatic'.

Change Scale to Fit Settings to Automatic
Check Print Preview: Press Ctrl + P to open the Print Preview and verify that your invoice now spans across multiple pages correctly at 100% scale.
Print Spreadsheets Perfectly

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. 1. Open your file in WPS: Launch WPS Spreadsheet and open your invoice or worksheet.
  2. 2. Access Page Layout: Click on the 'Page Layout' tab to view your scaling and print area options.
  3. 3. Adjust Print Settings: Ensure 'Width' and 'Height' are set to 'Automatic' to prevent unwanted shrinking.
  4. 4. Preview and Print: Click 'Print Preview' to confirm the layout across multiple pages, then hit 'Print'.
Fully compatible with Microsoft Excel (.xlsx, .xls) formats.Intuitive Print Preview with visual drag-and-drop page break adjustments.Free, lightweight, and fast to load on any device.Built-in PDF exporter for sharing professional multi-page invoices.
microsoft office alternative - wps office

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.