How to Print an Excel Spreadsheet on a Single Page Without Shrinking

Printing a spreadsheet in Microsoft Excel is notoriously frustrating. By default, Excel will print data at its actual size, blindly slicing rows and columns across as many physical pages as necessary. Handing a colleague a stack of disjointed pages where the data is completely separated from its header row is both unprofessional and confusing.

Fortunately, you do not need to manually adjust column widths, delete data, or change font sizes just to force your spreadsheet to fit onto a single sheet of paper. Excel includes a built-in scaling feature designed specifically to solve this exact problem.

Using the Fit to Page Scaling Option

The fastest and most reliable way to force your spreadsheet onto a single printed page is by adjusting the print scaling settings. This feature shrinks the entire document proportionally until it fits perfectly within the margins of your paper size.

1. Open your spreadsheet in Microsoft Excel.
2. Click on the File tab located in the top-left corner of the ribbon menu.
3. Select Print from the left-hand sidebar (or simply press Ctrl + P on your keyboard).
4. Look at the Settings section in the middle of the screen. At the very bottom of this list, you will see a scaling dropdown menu, which is usually set to No Scaling by default.
5. Click on the No Scaling dropdown menu to open it.
6. Select Fit Sheet on One Page from the available options.
7. Check the print preview on the right side of the screen. Your entire spreadsheet should now be visible on a single page.

Optimising the Page Layout

While “Fit Sheet on One Page” works perfectly, scaling a massive dataset down to a single piece of standard A4 or Letter paper can sometimes make the text too small to read comfortably. If your spreadsheet is particularly wide, changing the page orientation can significantly improve legibility.

1. While still in the Print menu, locate the Page Orientation setting (it is usually set to Portrait Orientation).
2. Click the dropdown menu and change it to Landscape Orientation.
3. Excel will instantly recalculate the scaling. Because Landscape mode is wider, Excel does not have to shrink the text as aggressively to make wide datasets fit, resulting in a much more readable printout.

How to Print Only Specific Cells

If you only need a portion of your spreadsheet to fit on the page, attempting to shrink the entire document is unnecessary. Instead, you should define a specific Print Area before scaling.

1. Return to your normal Excel worksheet view.
2. Click and drag your mouse to highlight exactly the cells you want to print.
3. Click on the Page Layout tab in the top ribbon menu.
4. Click the Print Area button, then select Set Print Area from the dropdown menu.
5. Now, press Ctrl + P to return to the Print menu, and select Fit Sheet on One Page as described above. Excel will now only shrink and print your highlighted selection, ignoring the rest of the document.