How to Fit a Spreadsheet on One Page in Excel

To fit a spreadsheet on one page in Excel, open the Page Layout tab and, in the Scale to Fit group, set both Width and Height to 1 page. Excel shrinks the sheet so it prints on a single page. To fit only the columns across one page, set Width to 1 page and leave Height on Automatic.

These steps are for Excel for Microsoft 365, Excel 2024, 2021, 2019, and 2016 on Windows, with separate steps for Excel for Mac and Excel for the web. They follow Microsoft’s Scale a worksheet and Fit to one page articles. Excel 2010 and 2013 use the same Page Layout and Page Setup controls.

One thing to know first: fitting to a page only shrinks the data. A large sheet squeezed onto one page can end up with tiny text, so the tips near the end cover how to keep it readable.

Fit a Sheet on One Page With Scale to Fit

1. Open the workbook and click the worksheet you want to print.
2. Click the Page Layout tab.
3. In the Scale to Fit group, open the Width list and choose 1 page.
4. Open the Height list and choose 1 page.
5. Look at the Scale box in the same group. It now shows the percentage Excel shrank the sheet to.
6. Press Ctrl+P to open the print screen, check the preview, and click Print.

If the Scale box shows a very low number, like 40%, the printed text will be small. Try the column-only option below or one of the readability tips.

Fit All Columns on One Page

Most wide spreadsheets don’t need to fit on one page from top to bottom. They need every column to fit across the page so nothing spills onto a separate sheet of paper.

1. On the Page Layout tab, set Width to 1 page.
2. Set Height to Automatic.
3. Press Ctrl+P and page through the preview.

Every column now fits across each page, and the rows continue onto as many pages as needed. Microsoft suggests this setting before forcing everything onto one page. Pair it with repeating the header row on every page so each page has its column labels.

Use the Print Screen Scaling Menu

You can also set scaling right before you print.

1. Click File > Print (or press Ctrl+P).
2. Under Settings, click the scaling menu at the bottom. It usually says No Scaling.
3. Choose one of these:
4. Fit Sheet on One Page to fit all rows and columns on one page.
5. Fit All Columns on One Page to fit the width and let rows continue.
6. Fit All Rows on One Page to fit the height and let columns continue.
7. Check the preview, then click Print.

This menu changes the same setting as Scale to Fit, so the choice is saved with the workbook.

Use the Page Setup Dialog

The Page Setup dialog gives you the same result and lets you type any page count, such as 2 pages wide by 1 tall.

1. On the Page Layout tab, click the small launcher arrow in the bottom-right corner of the Page Setup group. You can also press Alt+P, S, P.
2. On the Page tab, under Scaling, select Fit to.
3. Enter 1 page(s) wide by 1 tall.
4. Click OK.

To pick a size yourself instead, select Adjust to on the same tab and type a percentage.

Fit a Spreadsheet on One Page in Excel for Mac

1. Click the Page Layout tab, then click Page Setup.
2. Under Scaling, select Fit to and type 1 in both the pages wide and pages tall boxes.
3. Click OK.
4. Click File > Print and use the preview arrows to check every page.

To fit only the columns on a Mac, Microsoft’s Excel for Mac guide suggests entering 1 for the width and 9999 for the height.

Fit a Spreadsheet on One Page in Excel for the Web

Excel for the web doesn’t have the Scale to Fit group, but its print screen has a scaling choice.

1. Click File > Print, then choose what to print (for example, the active sheet).
2. In the print settings, open the Scaling list and choose Fit Sheet on One Page, Fit All Columns on One Page, or Fit All Rows on One Page.
3. Click Print to open the preview, then print.

If you don’t see the scaling option, click Editing > Open in Desktop App and use the steps above.

Save the One-Page Sheet as a PDF

Once the sheet fits on one page, you can save it as a one-page PDF.

1. Click File > Save As (or Save a Copy) and choose a location.
2. Set the file type to PDF (*.pdf).
3. Click Options if you want to choose the active sheet, a selection, or the entire workbook.
4. Click Save, then open the PDF and check that it’s one page.

The PDF uses the scaling you set on each sheet. Microsoft’s PDF export guide explains the other options.

Keep the Printout Readable

If one page makes the text too small, try one or more of these before printing:

• Switch to landscape. Click Page Layout > Orientation > Landscape. Wide sheets gain a lot of room this way.
• Use bigger paper. Click Page Layout > Size and choose Legal or A3, if your printer supports it.
• Narrow the margins. Click Page Layout > Margins > Narrow.
• Tighten the columns. AutoFit columns and rows to remove wasted space.
• Print only what you need. Select the cells, then click Page Layout > Print Area > Set Print Area.

Troubleshooting

There’s still a second page

Check that both Width and Height are set to 1 page. Then press Ctrl+End to see where Excel thinks your data ends. Stray formatting or a value far below or to the right of your data makes Excel print that area too. Delete those rows or columns, or set a print area.

My page breaks are ignored

Microsoft notes that Excel ignores manual page breaks when you use Fit to. If you want your own breaks to control the layout, use Adjust to with a percentage instead.

The small table doesn’t fill the page

Fit to only shrinks. It doesn’t enlarge a small table. To place a small table in the middle of the page, center the worksheet horizontally and vertically, or use Adjust to with a number above 100%.

How to undo the scaling

Click File > Print, open the scaling menu, and choose No Scaling. Or set Width and Height back to Automatic and Scale back to 100% on the Page Layout tab.

Frequently Asked Questions

Does Fit to One Page change how the sheet looks on screen?

No. Scaling only affects printing and PDF export. Your cells, fonts, and column widths stay the same on screen.

Do I have to set this for every sheet?

Yes. Scaling is saved separately for each worksheet. To change several at once, hold Ctrl and click their tabs before you change the setting, then right-click a tab and choose Ungroup Sheets when you’re done.

Will gridlines print on the one-page sheet?

Not by default. See how to print gridlines in Excel.