How to print an Excel sheet on one page

Quick answer: On the Page Layout tab, in the Scale to Fit group, set Width and Height to 1 page, then press Ctrl+P and print. You can do the same from the Page Setup dialog by choosing Fit to 1 page wide by 1 tall. If the result is too small to read, switch to Landscape, pick a larger paper size, or set a print area so Excel only shrinks the cells you actually need.

Applies to: Excel for Microsoft 365, Excel 2024, Excel 2021, Excel 2019 and Excel 2016 on Windows, which are the versions Microsoft lists for its scaling and page break articles. Excel for the web gets a short hedged section at the end. The scaling setting is saved with each worksheet, so a workbook with several sheets may need it set on each one.

Check what Excel thinks it is printing

Fitting a sheet to one page shrinks everything Excel plans to print, not just the table you can see. If there is a stray value, a space or some formatting far below or to the right of your data, Excel counts that range too and the real data ends up tiny. Before you change any scaling, press Ctrl+End: it should jump to what Excel treats as the last used cell. If that cell is well outside your table, clear the extra rows and columns, or set a print area instead.

Open the preview with Ctrl+P and look at the page count under the preview. That number is the one you are trying to bring down to 1, and it should update as soon as you change a setting on that screen.

The quickest route is the scaling menu on the Print screen. Microsoft’s scaling article confirms that this menu exists under File > Print > Settings and that No Scaling is the option that removes scaling again. The other labels below appear to be the ones recent versions use, so check the wording on your screen:

  1. Select File > Print or press Ctrl+P.
  2. Under Settings, open the last drop-down, which shows No Scaling by default.
  3. Choose Fit Sheet on One Page.
  4. Check the preview, then select Print.

The same drop-down has Custom Scaling Options, which opens the Page Setup dialog described below. Changing the setting here changes it for the sheet, so the next print uses it too until you set it back to No Scaling.

Use Scale to Fit on the Page Layout tab

The ribbon gives you the same control with more say over the result. These are the steps from Microsoft’s “Scale a worksheet” article:

  1. Open the worksheet you want to print and select the Page Layout tab.
  2. In the Scale to Fit group, set Width to 1 page.
  3. Set Height to 1 page as well if everything has to fit on a single sheet of paper.
  4. Look at the Scale box in the same group. It shows the percentage Excel had to use.
  5. Press Ctrl+P to check the preview, then select Print.

The Scale box is the useful part. Microsoft warns that forcing a sheet onto one page can make it hard to read, and that a low Scale value is a sign you should change the orientation or use larger paper. If the box shows something like 40%, the printout will be readable only up close.

Use the Page Setup dialog

The Page Setup dialog has the same option and lets you set orientation and paper size in one place:

  1. On the Page Layout tab, select the small launcher arrow at the bottom right of the Page Setup group.
  2. Open the Page tab.
  3. Under Scaling, select Fit to.
  4. Set it to 1 page wide by 1 tall.
  5. Select OK.

Microsoft notes two side effects of Fit to. Excel ignores any manual page breaks you added, and it only shrinks a sheet: it doesn’t stretch a small table to fill the page. If you want a fixed size instead, choose Adjust to on the same tab and type a percentage; values below 100% make the print smaller and values above 100% make it larger.

Fit all columns on one page instead

For a long list, one page can be the wrong target. A better result is all columns across one page width, with the rows flowing onto as many pages as they need. Microsoft’s steps: on the Page Layout tab, set Width to 1 page and leave Height on Automatic. On the Print screen, the scaling drop-down should also offer Fit All Columns on One Page for the same result, and Fit All Rows on One Page for the opposite case.

When the rows run over several pages, repeat the header row so each page is labeled. Go to Page Layout > Print Titles, click in Rows to repeat at top and select your header row. This option isn’t in the Microsoft articles cited here, so check the label in your version. It is separate from Freeze Panes, which only affects the screen; see Freeze Panes not working in Excel if that is what you were after.

When one page is too small to read

Excel can squeeze a large sheet onto one page, but past a certain point the text is unreadable. The Page Setup percentage also has a lower limit, which appears to be 10% in current versions, so a very large sheet may not fit at all. Before you accept a tiny printout, try these in order, checking the Scale box after each one:

  1. Switch to Landscape. Microsoft suggests this for sheets with many columns: Page Layout > Orientation > Landscape.
  2. Use a larger paper size if your printer takes one, under Page Layout > Size.
  3. Narrow the margins. Page Layout > Margins should offer a Narrow preset, which gives the content a little more room.
  4. Hide or drop columns you don’t need on paper, or set a print area.
  5. Fit columns only and let the rows run onto a second page, as described above.

Microsoft also points out that the printer’s paper size has to match the size set in the worksheet; if they differ, the printout may not match the preview. If the preview itself looks different from what you expect, the Word guide on print preview being different from the document covers the printer-side causes, which apply to Excel too.

A print area tells Excel to ignore everything outside a range, which keeps the scale higher. Microsoft’s articles recommend it for leaving out rows or columns you don’t need; the steps below are the usual ribbon route:

  1. Select the cells you want on paper.
  2. Go to Page Layout > Print Area > Set Print Area.
  3. Set Width and Height to 1 page again if you want the range on one sheet.

To go back to printing the whole sheet, use Page Layout > Print Area > Clear Print Area. A print area can stay in the file after you save it, so if a file only ever prints part of its data, an old print area is the first thing to clear.

Adjust page breaks in Page Break Preview

Page Break Preview shows where each printed page starts and ends, so you can see what is pushing the sheet onto a second page. Microsoft’s steps:

  1. Go to View > Page Break Preview, or select the Page Break Preview button on the status bar.
  2. Dashed blue lines are breaks Excel added on its own; solid lines are manual breaks.
  3. Drag a break line to move it. Moving an automatic break turns it into a manual one. If you can’t drag, turn on cell drag-and-drop under File > Options > Advanced.
  4. To start over, go to Page Layout > Breaks > Reset All Page Breaks.
  5. Return with View > Normal.

Dragging the outer edge of the blue area outward to cover the whole table should make Excel scale the page down to fit, which is a visual way to do the same job as Fit to. Manual breaks and Fit to don’t work together: Microsoft says that if your manual breaks are ignored, Fit to may be the reason, and you should switch to Adjust to in Page Setup. After you leave Page Break Preview, Excel may keep showing dashed lines in Normal view; Microsoft says you can hide them by clearing Show page breaks under File > Options > Advanced.

Why it still prints on several pages

Stray content or formatting outside the table

If Ctrl+End lands far from your data, Excel is including that empty-looking range. Select the extra rows below the table, right-click and choose Delete, do the same for extra columns, then save the file. The last used cell may only reset after a save. Objects such as shapes or comments placed far away can have the same effect; the guide to Excel cannot shift objects off sheet shows how to find them.

Hidden rows and columns

Hidden rows and columns shouldn’t print, but unhiding them by accident, or a filter being cleared, can bring back a wide block of data. Check for gaps in the row numbers or column letters before you print.

The setting is on another sheet

Scale to Fit and Page Setup apply to the active sheet. If you print the whole workbook, each sheet uses its own settings. To change several at once, Ctrl-click their sheet tabs to group them first, and ungroup them after you finish so later edits don’t hit every sheet.

Blank extra pages come out

Empty pages at the end of an Excel print job can come from formatting or a print area that reaches past the data. If blank pages appear from every app, look at the printer instead; see printer printing blank pages.

Excel for the web

Microsoft’s articles have a Web tab, but it wasn’t included in the copies fetched for this guide, so treat this as a pointer. In Excel for the web, File > Print opens a print settings panel where you can choose what to print, the orientation and a scaling option such as fitting the sheet on one page, before the browser’s own print dialog opens. Page Break Preview and the Page Setup dialog aren’t available in the browser the way they are on Windows, so for detailed layout work open the file in the desktop app.

Quick troubleshooting table

What you seePossible causeWhat to try
Fits on one page but the text is tinyToo many columns, or extra cells includedLandscape, larger paper, print area or fit columns only
Still prints on two or more pagesHeight left on Automatic, or a different sheet changedSet Width and Height to 1 page on the active sheet
Manual page breaks are ignoredFit to is selected in Page SetupSwitch to Adjust to, or remove the breaks
Only part of the data printsAn old print area is setPage Layout > Print Area > Clear Print Area
Ctrl+End jumps far past the dataStray values or formatting in empty cellsDelete the extra rows and columns, then save
Printout doesn’t match the previewPrinter paper size differs from the sheetMatch the paper size in Page Setup and the printer

Sources

How we write our guides: read our editorial policy.

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *