You can make a wide Excel sheet print on one page, or one page wide with the rows running onto further pages, in about a minute with Scale to Fit. Below are both versions, how to tell whether the printout will still be readable, and why Fit to sometimes looks like it isn't working.
These steps are for Excel for Windows. Microsoft's pages list them as applying to Excel for Microsoft 365, 2024, 2021, 2019 and 2016.
Set a print area first if you don't need every column
The less Excel has to squeeze, the bigger your text stays. If only part of the sheet matters, say columns A to F but not G to Z (the example Microsoft uses), print just that part:
- Select the cells you want to print.
- Go to Page Layout > Page Setup > Print Area > Set Print Area.
Once set, only the print area prints, and it's saved with the workbook, according to Microsoft's print area page. To check it, use View > Page Break Preview.
One trap: if you select several separate ranges (holding Ctrl), each print area prints on its own page. The same happens if you use Print Area > Add to Print Area with cells that aren't next to the existing area. Only adjacent cells extend it. That will undo your one-page goal, so keep the range in one block.
Print all columns on one page wide (best for long lists)
This is the setting most people actually want. Every column fits across the page, and the rows continue onto as many pages as they need.
- Select the Page Layout tab.
- In the Scale to Fit group, set Width to 1 page.
- Leave Height on Automatic.
- Press Ctrl+P and select Print.
If the sheet has many columns, switch to landscape first: Page Layout > Page Setup > Orientation > Landscape. A larger paper size also helps, under Page Layout > Page Setup > Size. Both Microsoft suggests as ways to give your data more room.
Fit the whole sheet on a single page (best for small sheets)
For a sheet that's only a little too big, set Height to 1 page as well as Width. Everything then lands on one sheet of paper.
On a long list this is a bad idea: Excel shrinks the whole thing until it fits, and Microsoft itself warns the result may be hard to read.
Check the Scale box before you print
After you set Width and Height, look at the Scale box in the same Scale to Fit group. It shows the percentage Excel has shrunk the sheet to. Microsoft's advice is that if the number is low, make other adjustments before printing: landscape orientation, bigger paper, or a tighter print area.
Microsoft doesn't give a cut-off for when text becomes too small, so that's your judgment. The quick test is Print Preview (Ctrl+P): if you're squinting at the preview, the paper will be worse. Switching from "1 by 1" to "1 wide, Automatic tall" is usually the biggest gain.
Use the Page Setup dialog instead (and if Freeze Panes is on)
The same setting lives in the Page Setup dialog. Microsoft's fit-to-one-page steps:
- Go to Page Layout and click the Page Setup launcher (the small arrow at the bottom-right of the group).
- In the Page Setup dialog, select the Page tab.
- Under Scaling, select Fit to.
- Choose 1 page(s) wide by 1 tall.
- Select OK.
For one page wide only, enter 1 in the wide box and clear the tall box, or type any page counts you like into the two Fit to boxes.
This route matters if you've frozen header rows. Microsoft notes that Page Layout view isn't compatible with Freeze Panes, and recommends using the Fit to options in this dialog so you don't have to unfreeze. If you haven't set up frozen headers yet, see how to freeze rows and columns in Excel.
You can also open the dialog with the keyboard:
Alt+P, S, P
Why Fit to seems not to work
Your manual page breaks disappeared. Excel ignores manual page breaks when you use Fit to, per Microsoft. You get one or the other. If you need breaks in specific places, turn Fit to off and scale by percentage instead (below).
A small sheet didn't grow to fill the page. To enlarge, use Adjust to with a number above 100%.
Extra pages still print. Check for multiple print areas in Page Break Preview. Each one prints on its own page regardless of the Fit to setting.
The printout came out a different size than the preview. The paper size in your printer properties must match the paper actually in the printer. If they differ, Excel adjusts the printout to fit the paper in the printer.
Scale by an exact percentage instead
- Open the Page Setup dialog (launcher or Alt+P, S, P).
- On the Page tab, choose Scaling > Adjust to.
- Enter a percentage. Below 100% shrinks the sheet; above 100% enlarges it.
You can reach the same box from File > Print > Settings > Custom Scaling Options. Check Print Preview and repeat until it looks right.
Turn scaling back off
Go to File > Print > Settings and choose No Scaling.
Excel for Mac and Excel for the web
The steps above are the Windows ones. Microsoft has a separate page for printing a sheet on one page in Excel for Mac, and the fit-to-one-page article has a Web tab. Follow those if you're not on Windows, since menu names may differ.
