Printing Problems

How to Make an Excel Spreadsheet Fill One Printed Page

Partner Editor Oct 9, 2026 869 views

Question details

The user wants to enlarge a small Excel spreadsheet so that it completely fills a single printed page.

How to Make an Excel Spreadsheet Fill One Printed Page

Product: Excel
Device & OS: not provided
Scenario: Printing a small worksheet that currently occupies only a fraction of the printed paper.
Observed behavior: The 'Fit to Page' feature only shrinks larger sheets and fails to enlarge small data to fit the entire page.

Before you start

Before adjusting the print scaling, verify that you have selected the correct paper size and page orientation (Portrait or Landscape) for your specific printing needs.

Solution 1Recommended

Increase Scaling Percentage in Page Setup

Manually increase the print scaling percentage to enlarge the spreadsheet to fit the page.

The 'Fit to Page' option in Excel is primarily designed to shrink a large spreadsheet to fit onto a single page, but it does not enlarge a small spreadsheet. To make small content fill a page, you need to manually adjust the scaling percentage.

Set the Print Area

Highlight all the cells you want to print. Go to the Page Layout tab on the ribbon, click 'Print Area', and select 'Set Print Area'.

Open Page Setup

Navigate to File > Print to open the print preview screen. Click on the 'Page Setup' link located at the bottom of the print settings menu.

Adjust the Scaling Percentage

In the Page Setup dialog box, go to the 'Page' tab. Under the 'Scaling' section, select the 'Adjust to:' radio button and increase the percentage. You can scale it up to 400%.

Preview and Refine

Click 'OK' and check the Print Preview to see how the spreadsheet fits on the page. Repeat the process to adjust the percentage up or down until it fills the page perfectly.

Increase Scaling Percentage in Page Setup

Use Page Break Preview: You can also use the Page Break Preview view from the View tab to easily drag page boundaries and visually manage what prints on one page.

Efficient Spreadsheet Printing

Easily Scale and Print Spreadsheets with WPS Office

WPS Spreadsheet provides an intuitive print preview and page layout tool, making it incredibly easy to scale your worksheets to perfectly fit one printed page without the guesswork.

1. Open your spreadsheet: Launch WPS Office and open your desired spreadsheet document.
2. Set the Print Area: Highlight the data you want to print, go to the Page Layout tab, and click Print Area > Set Print Area.
3. Adjust Scaling in Print Preview: Click the Print Preview icon. From the top toolbar, use the Zoom/Scaling drop-down to quickly enlarge the content until it fits the page.
4. Center the Content: Click the Page Setup button in the preview, navigate to the Margins tab, and check 'Horizontally' and 'Vertically' to center your enlarged spreadsheet.

Visual Print Preview for real-time scaling adjustmentsFully compatible with Microsoft Excel (.xlsx) formatsFree and lightweight alternative for powerful data processingEasy-to-use Page Setup options to center and scale content

microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't the 'Fit Sheet on One Page' option enlarge my data?

The 'Fit to Page' setting is specifically programmed to scale down or shrink large amounts of data to fit onto a single page to prevent it from spilling over into multiple pages. It is not designed to scale up small datasets. You must manually increase the scaling percentage to enlarge it.

How can I perfectly center my small spreadsheet on the printed page?

Go to Page Setup, click on the Margins tab, and look for the 'Center on page' section at the bottom. Check the boxes for both 'Horizontally' and 'Vertically'. This will center your scaled spreadsheet directly in the middle of the paper.

Can I change the row height and column width to fill the page instead of using scaling?

Yes, you can manually increase row heights and column widths to make the data physically larger on the sheet. However, adjusting the scaling percentage in Page Setup is much faster and keeps your original layout compact for standard screen viewing.

Document & File Issues