Printing Problems

How to Print All Columns on One Page for Every Excel Worksheet

Chanuka Geekiyanage Sep 25, 2026 872 views

Question details

The user wants to configure an Excel workbook so that every worksheet scales to fit all columns on a single printed page.

How to Print All Columns on One Page for Every Excel Worksheet

Product: Excel
Device & OS: not provided
Scenario: Preparing a multi-sheet Excel workbook for printing or exporting to PDF without columns spilling over to extra pages.
Observed behavior: Excel does not have a single universal command to apply fit-to-page column settings across all worksheets simultaneously; print settings are generally stored separately for each sheet.

Before you start

Ensure your printer is properly connected and your paper size and orientation are correctly set before adjusting scaling options, as this will affect how your columns fit on the page.

Solution 1Recommended

Configure Scaling and Print the Entire Workbook

Adjust the scaling for each worksheet individually to fit all columns on one page, then print the entire workbook together.

Because Excel stores print settings on a per-sheet basis, you will generally need to adjust the scaling for each worksheet to ensure everything fits perfectly when printing the entire workbook.

Set the Print Area

Navigate to the Page Layout tab, highlight the data you want to print on the first sheet, click Print Area, and select 'Set Print Area'.

Adjust Page Scaling

Go to File > Print. Under the Settings section, click the scaling dropdown (usually says 'No Scaling') and select 'Fit All Columns on One Page'.

Repeat for Other Sheets

Click on the other worksheet tabs in your workbook and repeat the process to ensure every sheet is scaled properly.

Print Entire Workbook

Once all sheets are configured, go to File > Print, change the first setting dropdown from 'Print Active Sheets' to 'Print Entire Workbook', and click Print.

Configure Scaling and Print the Entire Workbook

Verifying Print Previews: Always scroll through the print preview pages before clicking Print to guarantee that the columns on every sheet are correctly scaled.

Solution 2

Export the Workbook to PDF for Consistent Layouts

Save the configured workbook as a PDF to preserve the column scaling across all sheets for digital distribution.

Easily Scale and Print Multiple Worksheets with WPS Office

WPS Spreadsheet provides an intuitive Page Layout interface to quickly fit all columns on one page, manage multi-sheet print settings, and export workbooks seamlessly to PDF.

1. Open Workbook: Open your Excel workbook (.xlsx) using WPS Spreadsheet.
2. Adjust Print Settings: Go to the Page Layout tab and use the quick scaling tools to fit your columns to one page.
3. Print Entire Workbook: Click on Menu > Print, select 'Entire workbook', and verify your settings in the preview window.
4. Export to PDF: Use the 'Export to PDF' button on the main toolbar to instantly save a digital copy with your preserved layouts.

Easily scale worksheets to fit all columns on a single printed page.Highly compatible with Microsoft Excel formats (.xlsx, .xls).Built-in, one-click PDF export to preserve complex print layouts.Free, lightweight, and features a user-friendly interface.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel print my columns across multiple pages?

By default, Excel prints at a 100% scale. If your columns exceed the physical width of the paper based on your margins and orientation, they will spill over to additional pages. You need to change the scaling option to 'Fit All Columns on One Page' to resolve this.

Can I apply 'Fit to Page' settings to all sheets at once?

While you can group sheets by holding the Shift key and clicking the sheet tabs to apply certain page setup settings simultaneously, Excel often requires you to verify and apply the 'Fit All Columns on One Page' setting to each sheet individually to ensure varying column widths scale correctly.

How do I ensure my print area is set correctly before scaling?

Highlight the specific cells you want to print, go to the Page Layout tab, click Print Area, and choose 'Set Print Area'. This ensures that only the relevant data is taken into account when Excel scales the columns to fit on one page.

Document & File Issues