Printing Problems

How to Fix Excel 2019 Scaling and Multi-Page Printing Problems

Guest Writer Oct 10, 2026 869 views

Question details

The user wants to print an Excel worksheet with all columns fitting on a single page instead of producing dozens of pages.

How to Fix Excel 2019 Scaling and Multi-Page Printing Problems

Product: Microsoft Excel 2019
Device & OS: not provided
Scenario: Printing a wide worksheet in Excel 2019 without spanning columns across multiple unnecessary pages.
Observed behavior: The worksheet prints across dozens of pages because the columns exceed the width of a single printed page.

Before you start

Before adjusting the scaling settings, preview your worksheet in the Print menu to see exactly how many pages it currently takes up and identify which columns are spilling over.

Solution 1Recommended

Use the Scale to Fit Feature to Condense Columns

Adjust the scaling settings in the Page Layout tab to force Excel to fit all your columns onto a single page width, while allowing rows to flow naturally.

Excel's Scale to Fit feature is the most effective way to manage wide worksheets. By restricting the width to one page, Excel automatically reduces the print scale so that all columns fit horizontally.

Open Page Layout

Navigate to the Page Layout tab located on the top ribbon of your Excel workbook.

Adjust Width Settings

Locate the Scale to Fit group. Click the drop-down next to 'Width' and select '1 page'.

Set Height to Automatic

Ensure the 'Height' setting is set to 'Automatic'. This allows the rows to continue across multiple pages if your data is long.

Optimize Orientation (Optional)

If your columns are compressed too much, go to the Page Setup group, click 'Orientation', and select 'Landscape' to give your columns more horizontal space.

Use the Scale to Fit Feature to Condense Columns

Readability Warning: If you decide to also set the Height to '1 page' to fit the entire worksheet on a single sheet of paper, the text may shrink significantly and become difficult to read. Consider using a larger paper size (like Legal or A3) if you need everything on one page.

Print perfectly with WPS Office

Easily Scale and Print Spreadsheets with WPS Office

WPS Office provides highly intuitive page layout and printing controls, allowing you to quickly fit all columns on one page. It is free, lightweight, and fully compatible with Microsoft Excel formats.

1. Open Your File: Launch WPS Spreadsheet and open the document you wish to print.
2. Access Print Preview: Click on the Print icon or press Ctrl+P, then click on 'Print Preview' to see your current layout.
3. Select Scaling Options: In the Print Preview toolbar, look for the Page Setup or Scaling drop-down.
4. Fit to One Page: Select 'Fit All Columns on One Page' from the list of scaling options.
5. Print the Document: Verify the layout looks readable on the preview screen, then click 'Print' to send it to your printer.

Fully compatible with Microsoft Excel (.xlsx, .xls) files and formattingIntuitive Print Preview and Scale to Fit optionsLightweight, fast, and completely free to useFamiliar user interface requiring zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why is my Excel spreadsheet printing so small?

When you force a large spreadsheet to fit on one page using the Scale to Fit option, Excel shrinks the font and row sizes to make everything fit. To improve readability, change the page orientation to Landscape, or only fit the columns to one page while leaving the height automatic.

Can I scale and print only a specific part of my worksheet?

Yes. Highlight the specific cells you want to print, navigate to the Page Layout tab, click 'Print Area', and select 'Set Print Area'. After setting this, your scaling settings will only apply to the highlighted section.

How do I print row and column headings on every printed page?

Go to the Page Layout tab and click 'Print Titles'. In the Page Setup dialog box under the Sheet tab, select the rows you want to repeat at the top or columns to repeat at the left, then click OK.

Document & File Issues