To stretch an Excel spreadsheet so it fills more of the printed page, open the Page Layout tab, click the Dialog Box Launcher in the Page Setup group, and on the Page tab choose Adjust to and enter a percentage greater than 100%. If the sheet is too big instead, use the Scale to Fit group to set Width to 1 page.
Applies to: Excel for Microsoft 365, Excel 2024, Excel 2021, Excel 2019 and Excel 2016 on Windows, with a separate section for Excel for Mac. Checked against Microsoft Support on October 7, 2026.
What stretching means when you print from Excel
Excel has two different scaling tools, and they do opposite jobs. Knowing which one you need saves a lot of wasted paper.
- Fit to (and the Width and Height boxes on the ribbon) shrinks a sheet so it lands on the number of pages you choose. Microsoft states that with this option Excel does not stretch the data to fill the pages. A small table stays small.
- Adjust to prints the sheet at a percentage of its normal size. A value below 100% reduces it, and a value above 100% enlarges it. This is the setting that makes a small table take up more of the paper.
So if your printout sits in one corner with a lot of white space around it, you want Adjust to. If your printout runs onto extra pages or cuts off columns, you want Fit to or Scale to Fit.
| What you see in the preview | Setting to use |
|---|---|
| Small table, lots of empty paper | Adjust to, above 100% |
| Last few columns spill onto a second page | Width: 1 page, Height: Automatic |
| Wide table, tiny text after fitting | Landscape orientation, narrower margins, or larger paper |
| Blank or unwanted cells are printing | Set Print Area |
| Data hugs the top-left corner | Center on page |
Stretch a small spreadsheet to fill the page (Windows)
Scaling only changes the printout. The font sizes, column widths and data in the worksheet itself stay the same.
- Open the worksheet you want to print and select the Page Layout tab on the ribbon. The page setup tools appear.
- In the Page Setup group, click the Dialog Box Launcher, the small arrow at the bottom-right corner of the group. The Page Setup dialog box opens.
- Stay on the Page tab and look under Scaling.
- Choose Adjust to and enter a percentage greater than 100%. For a table that covers roughly two thirds of the page width, 140% is a sensible first try. Confirm the dialog box to save the setting.
- Press Ctrl+P, or go to File > Print, and check the preview. The table should now cover more of the page.
- If there is still empty space, go back and raise the percentage. If a column or row has jumped to a second page, lower it a little. Two or three tries usually finds the largest size that still fits.
There is no button that works out the percentage for you, so the preview is your guide. A quick way to estimate a starting value: if the table fills about half the width of the page in the preview, something close to 200% will take it near the right edge, provided the rows also have room to grow.
Change the scaling from the Print screen instead
You can reach the same setting without leaving the print preview, which is handy when you are already there.
- Press Ctrl+P to open the Print screen.
- Under Settings, open the scaling option and choose Custom Scaling > Custom Scaling Options.
- Click Page, and in the Adjust to box choose the percentage you want.
- Return to the preview and check the result before you print.
Fit a large spreadsheet to the page width
When the problem is the opposite one, and columns are being pushed onto extra sheets of paper, let Excel shrink the sheet just enough to fit.
- Select the Page Layout tab.
- In the Scale to Fit group, open the Width box and select 1 page.
- In the Height box, select Automatic. All columns now print on one page across, and the rows continue onto as many pages as they need.
- Look at the number in the Scale box. It shows how much Excel reduced the sheet. A low number means small text, so check the preview before printing.
To print on a specific number of pages, open the Page Setup dialog box with the Dialog Box Launcher, and on the Page tab, under Scaling, enter the number of pages in both Fit to boxes. Keep in mind that Excel ignores manual page breaks when you use Fit to. If you rely on your own breaks, use Adjust to instead.
Microsoft documents all of these options on its Scale a worksheet support page.
Use more of the paper before you scale
Scaling works better when the page itself is set up well. These four changes each give the data more room, so you need less shrinking or can enlarge further.
Switch to landscape
A table that is wider than it is tall suits a sideways page. Go to Page Layout > Page Setup > Orientation and click Landscape.
Narrow the margins and center the data
On the Page Layout tab, in the Page Setup group, click Margins and choose Narrow. For exact control, click Custom Margins and enter sizes in the Top, Bottom, Left and Right boxes. In the same dialog box, under Center on page, select the Horizontally or Vertically check box so the leftover space is shared evenly around the table instead of sitting on one side. Microsoft lists these choices under Set page margins before printing a worksheet.
Print only the cells you need
Stray notes or helper columns far from your table make Excel treat the sheet as much larger than it looks, which leaves the real data small. Select the cells you want, then on the Page Layout tab, in the Page Setup group, click Print Area > Set Print Area. The print area is saved with the workbook. For a one-time job, you can print only a selection in Excel without setting a permanent area. Microsoft covers the details in Set or clear a print area on a worksheet.
Choose a larger paper size
If your printer can take bigger paper, go to Page Layout > Page Setup > Size and choose the size you have loaded. More paper means less reduction for a sheet with many columns.
Scale a sheet in Excel for Mac
These steps apply to Excel for Microsoft 365 for Mac, Excel 2024 for Mac and Excel 2021 for Mac.
- On the Page Layout tab, select Page Setup.
- On the Page tab, select Adjust to and choose the percentage to reduce or enlarge the sheet.
- To fit the page width instead, select the Fit To check box, enter 1 in the pages wide box and 0 in the Tall box so the number of pages tall is left open.
- On the File menu, select Print and check the preview.
Microsoft’s Mac instructions include a note that printed data never exceeds 100%. If a higher percentage makes no difference in your Mac preview, enlarge the content itself by increasing the font size and widening the columns. The full Mac steps are on Microsoft’s Scale the sheet size for printing in Excel for Mac page.
Confirm the result and undo the changes
The preview at File > Print shows exactly what will come out of the printer. Select the Show Margins box in the preview if you want to see where the margins fall.
To put things back:
- Scaling: go to File > Print > Settings and choose No Scaling.
- Margins: click Margins on the Page Layout tab and choose Normal.
- Print area: on the Page Layout tab, in the Page Setup group, click Clear Print Area. This removes every print area on the worksheet.
Troubleshooting
The printout is still tiny
Check whether a fit option is still switched on. In File > Print > Settings, an option such as Fit Sheet on One Page overrides your percentage and squeezes everything onto a single sheet. Change it to No Scaling, then set Adjust to again. If the text is still small, the print range probably includes cells you did not mean to print, so set a print area.
The enlarged sheet now spills onto a second page
The percentage is slightly too high for the paper. Lower it in small steps, switch to Landscape, or choose Narrow margins to win back space.
There is empty space on only one side
Scaling enlarges width and height together, so a table rarely fills the page in both directions. Use the Center on page check boxes to balance the gap, or try the other orientation so the page shape is closer to the shape of the table.
Your manual page breaks are being ignored
That is expected with Fit to. Switch to Adjust to and enter a percentage if the breaks need to stay where you put them.
You cannot use Page Layout view
Page Layout view is not compatible with the Freeze Panes command. You do not need that view for scaling. Use the options on the Page tab of the Page Setup dialog box, which work while panes are frozen.
Frequently asked questions
Does Fit Sheet on One Page stretch a small spreadsheet?
No. The fit options only reduce a sheet so it lands on the number of pages you ask for. Microsoft notes that Excel does not stretch the data to fill the pages. To enlarge, use Adjust to with a percentage above 100%.
Will scaling change my font sizes or column widths?
No. Scaling affects the printed output only. The worksheet looks the same on screen, and you can return to normal size at any time with No Scaling.
Can I fit all columns on one page without shrinking the rows onto one page too?
Yes. In the Scale to Fit group, set Width to 1 page and leave Height on Automatic. The columns stay together and long lists continue onto more pages.
Are the margins and print area saved with the file?
Yes. Microsoft states that page margins are stored with the worksheet, and the print area is saved, when you save the workbook. Margins belong to the individual worksheet, so repeat the setup on any other sheets you plan to print.
How do I print a wide spreadsheet at a readable size?
Combine the options: switch to Landscape, choose Narrow margins, set a print area that leaves out columns nobody needs on paper, and only then fit the width to one page. Each step reduces how much Excel has to shrink the text.
Once the preview looks right, print a single test page before a long run. If you print the same report regularly, save the workbook so the margins and print area are ready next time.
Related: change the paper size in Excel.
Related: print a book in Word.
Related: remove all page breaks in Excel.
Related: change the zoom level in Excel.
Related: How to Put a Watermark in Excel.
Related: how to center a page horizontally in Excel.
Matt Jacobs has been working as an IT consultant for small businesses since receiving his Master’s degree in 2003. While he still does some consulting work, his primary focus now is on creating technology support content for SupportYourTech.com.
His work can be found on many websites and focuses on topics such as Microsoft Office, Apple devices, Android devices, Photoshop, and more.