To make an Excel 2010 spreadsheet fit on one page, click File > Print, then change the last setting (it says No Scaling by default) to Fit Sheet on One Page. The preview on the right updates to show everything on a single page. You can also set it permanently on the Page Layout tab: in the Scale to Fit group, set Width to 1 page and Height to 1 page.
Shrinking a large sheet can make the text tiny, so the tips below help it fit while staying readable. These steps also work in Excel 2013, 2016, 2019, 2021, and Microsoft 365.
Method 1: Fit Sheet on One Page in the Print screen
- Click File > Print (or press Ctrl + P).
- Under Settings, click the last option, No Scaling.
- Choose Fit Sheet on One Page.
- Check the preview, then click Print.
Other scaling choices include Fit All Columns on One Page (best for long lists) and Fit All Rows on One Page.
Method 2: Scale to Fit on the Page Layout tab
- Click the Page Layout tab.
- In the Scale to Fit group, set Width to 1 page.
- Set Height to 1 page, or Automatic if you only need the columns to fit.
This setting is saved with the workbook, so it applies every time you print. Or open the Page Setup dialog (click the small arrow in the Page Setup group), and on the Page tab choose Fit to 1 page(s) wide by 1 tall.
Make it fit without tiny text
- Switch to landscape: Page Layout > Orientation > Landscape. Wide sheets fit much better.
- Use narrow margins: Page Layout > Margins > Narrow.
- Set a print area: Select just the cells you need, then Page Layout > Print Area > Set Print Area.
- Hide extra columns: Right-click column letters you don’t need to print and choose Hide.
- Shrink column widths: Double-click column borders to AutoFit, and turn on Wrap Text for long headers.
- Use larger paper: Legal (8.5 x 14) or Tabloid (11 x 17) if your printer supports it.
Check page breaks
Click View > Page Break Preview. Blue lines show where pages split. Drag the dashed blue lines to the edges of your data to force everything onto one page. Click View > Normal to go back.
Print row headers on every page instead
If the sheet is too big to fit legibly on one page, print it on several pages with titles repeated: Page Layout > Print Titles, then set Rows to repeat at top.
Related: Fit everything on one page in Word.
Frequently asked questions
Why is my spreadsheet still printing on two pages?
Check for data or formatting in far-off cells, a manual page break, or a print area that’s too large. Use Page Break Preview to see what’s included.
What’s the smallest Excel will scale?
Excel can scale down to 10% of normal size, which is usually unreadable. If it drops below about 60%, try landscape or a print area.
How do I save the sheet as a one-page PDF?
Set Fit Sheet on One Page, then choose File > Save As and pick PDF.
Kermit Matthews runs Live2Tech from just outside Philadelphia. He is an IT specialist with over 20 years of experience, from a university help desk to small-business IT, IT management and his own consulting practice, and has written tech guides full time since 2020. Steps are checked against the current software on a real device or the maker’s official documentation. More about Kermit.