Excel Set Print Area to Fit on One Page: Steps and Tips

To set an Excel print area and fit it on one page, select the cells you want, choose Page Layout > Print Area > Set Print Area, then set Page Layout > Scale to Fit to Width: 1 page and Height: 1 page. This defines what prints and scales that content to one sheet of paper; check File > Print before printing, because fitting everything can make small text difficult to read.

Print area and scaling are different settings

A print area tells Excel which cells to include in a worksheet’s printout. It does not, by itself, make those cells fit on a single page. Scaling controls how large the selected print content appears on paper. To get a one-page result, you generally need both settings: a suitable print area and a scaling choice that fits its width and height onto one page.

For example, suppose a monthly report occupies A1:H35, but notes in columns J and K should not appear on the printout. Setting A1:H35 as the print area excludes those notes. Choosing one page for both width and height then shrinks the report, if necessary, so it occupies one printed page. If you use scaling without setting a print area, Excel may include other used cells on the worksheet, including content far from the report.

These settings affect printing and print preview, not the worksheet’s actual cell sizes or the way the data appears during normal editing. They also do not delete or hide the cells outside the print area.

Set the print area and fit it to one page

In Excel for Microsoft 365 on Windows, use these steps:

Select the range you want to print. Drag across the cells, or click the first cell and Shift-click the last cell.
Open the Page Layout tab, select Print Area, and choose Set Print Area.
In the Scale to Fit group on the Page Layout tab, set Width to 1 page and Height to 1 page.
Choose File > Print to inspect the preview. Confirm that the content is on one page and that the text is still legible.

If the Scale to Fit controls are not visible, the Excel window or ribbon may be too narrow. Maximize the window, expand the ribbon, or open the Page Setup dialog using the small dialog box launcher in the Page Setup group. You can also use the print screen’s scaling menu: choose File > Print, open the scaling options, and select Fit Sheet on One Page. The wording and availability of print options can vary slightly by build and printer.

Check the print preview before printing

Print preview is the quickest way to catch a layout problem. Choose File > Print or press Ctrl+P on Windows. The preview shows how Excel will paginate and scale the sheet with the current printer and page settings. Look at the page count, the outside edges of the report, and the size of headings and numbers—not just whether the preview says one page.

If the preview shows more than one page, check that both Width and Height are set to one page, and confirm the intended print area is active. If it shows one page but the content is too small, fitting the entire range in both directions is the reason: Excel is reducing the whole range until its longest dimension fits. Consider changing the layout or using a less restrictive scaling option instead of accepting an unreadable page.

Printing to PDF can be a useful final check when you need to share a fixed layout. In the print screen, select an available PDF printer or PDF output option, then inspect the resulting page at normal viewing size. A PDF preview can reveal clipped columns or tiny type before you send a print job.

Choose the right fit option

“Fit on one page” can mean different things. The best setting depends on whether keeping every row together matters more than preserving readable text. Excel’s print screen commonly offers these choices:

Fit Sheet on One Page: Shrinks the sheet’s printable content to one page wide and one page tall. This is the strict one-page option, but it can shrink a large worksheet substantially.
Fit All Columns on One Page: Keeps the columns together horizontally but allows rows to continue onto additional pages. This often works well for long lists with many columns.
Fit All Rows on One Page: Keeps rows together vertically but may split a wide worksheet across multiple pages.
No Scaling: Prints at the current scale and uses page breaks to divide content as needed.

For a short summary table, fitting both width and height to one page may be appropriate. For a transaction list with 200 rows, fitting all rows onto one page will usually make the text too small. Fitting all columns onto one page and letting the list continue onto several pages is often more usable. These choices change the layout; they do not alter the underlying data.

Improve readability before reducing the scale

Before shrinking a worksheet, try changes that create more room on the page. Select Page Layout > Orientation > Landscape for a wide report. A landscape page may fit extra columns without reducing text as much. Under Page Layout > Margins, a narrower margin setting can also increase the printable area, although the printer may still have unprintable edges.

Other useful adjustments include:

Remove blank rows and columns from the print area if they are not needed.
Reduce unnecessary column widths, or wrap long headings so they do not force columns wider than necessary.
Use a smaller but still readable font, and avoid oversized titles or excessive spacing.
Choose the correct paper size under Page Layout > Size, such as Letter or A4, to match the paper that will actually be used.
Hide helper columns or rows that are not part of the report, if they should not appear in the printout.

Make one change at a time and revisit print preview. A sheet may look comfortable on screen but become difficult to read when scaled down to a physical page. There is no universal minimum font size for every report; the audience, printer, and viewing conditions matter.

Manage, clear, and verify a print area

Excel stores a print area with the worksheet in the workbook. If the worksheet has a defined print area, printing the sheet generally uses that range rather than every populated cell. To remove it, choose Page Layout > Print Area > Clear Print Area. Then set a new range if the report has changed.

A print area can be helpful when a worksheet contains a dashboard alongside calculations, or when only a particular section is meant for distribution. If the report grows, however, a previously defined area may omit new rows or columns. Revisit the range after adding content and confirm the preview includes the latest information.

You can also select nonadjacent ranges before setting a print area, but separate print areas are printed as separate areas rather than being treated as one continuous rectangle. They may therefore appear on different pages. If you need a single coherent page, it is usually simpler to arrange the desired content in one contiguous range and set that range as the print area.

Repeat column headings on later pages by using Page Layout > Print Titles when a report spans multiple pages. This feature is useful for long reports, but it does not make the entire report fit on one page; it repeats selected rows or columns to make each page easier to interpret.

Common problems and how to fix them

The preview includes extra blank pages. Check whether the print area extends farther than intended or whether formatting exists in distant rows or columns. Clear the print area and set the exact range again. Also inspect page breaks and margins in the preview.

The printout is one page but unreadable. Excel is scaling too much content into too little space. Try landscape orientation, narrower margins, a smaller print area, or the Fit All Columns on One Page option so that rows can continue onto additional sheets. If the report truly must be one page, simplify it or use a larger paper size supported by the printer.

Some columns or rows are missing. The set print area may not include them, or they may be hidden. Check the selected range, unhide any required rows or columns, and inspect the preview again. Also verify that the chosen paper size and orientation are suitable.

The printed result differs from the worksheet view. Excel paginates according to print settings and the selected printer, so screen gridlines and on-screen column widths are not a reliable preview of the page. Use File > Print and confirm the printer, paper size, orientation, margins, and scaling there.

Windows, Mac, and Excel for the web

The steps above describe Excel for Microsoft 365 on Windows. In Excel for Mac, select the cells, use the Page Layout tab’s print-area controls where available, and check the result through File > Print. The Mac print workflow and available scaling controls can differ by version, so use the print preview and its scaling settings to choose a one-page fit. The common print shortcut is Command+P on Mac; on Windows it is Ctrl+P.

Excel for the web has a different interface and may not offer the same page-layout controls as the desktop application. If you cannot find a control for setting or scaling a print area in the web version, open the workbook in the desktop Excel app and apply the settings there. In either version, confirm the final print preview rather than assuming a worksheet view represents the printed page.

Frequently Asked Questions

How do I print an Excel sheet on one page?
Choose File > Print and select Fit Sheet on One Page in the scaling options, or set the Page Layout Scale to Fit width and height to one page. Preview the result to check readability.

Does setting a print area automatically fit it on one page?
No. A print area defines which cells Excel prints. Set scaling separately—such as Width: 1 page and Height: 1 page—to fit that content onto one sheet of paper.

How can I fit all columns on one page without shrinking every row?
Use the Fit All Columns on One Page scaling option in the print settings. Excel can then print the rows over multiple pages while keeping the columns together horizontally.

How do I remove a print area in Excel?
Go to Page Layout > Print Area > Clear Print Area. Then check File > Print to confirm Excel is using the intended range.

Why is my Excel printout so small?
Fitting a large range to one page forces Excel to reduce its scale. Use landscape orientation, adjust margins, narrow the print area, or allow the report to span multiple pages to preserve readable text.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.