Excel: Expand Print Area to Fit a Page

To make an Excel printout fit a page, select the cells you want, choose Page Layout > Print Area > Set Print Area, then use Page Layout > Scale to Fit to set Width and Height to 1 page. This sets what prints and how it is scaled; those are separate controls, and the print preview shows whether the result is readable.

Print area and page scaling are different

A print area is the range of worksheet cells Excel is allowed to print. If a print area is set, cells outside it are excluded, even if they contain data. Scaling controls how that selected content is sized across the available printed pages. Changing one setting does not necessarily change the other: making the print area larger can include more cells, but it does not automatically make the enlarged range fit on one sheet of paper.

This distinction helps diagnose the common complaint that a worksheet is cut off or prints too small. A missing column may be outside the print area, while a complete table spread over several pages is usually a scaling or page-layout issue. Start by identifying the exact cells that should print, then decide whether the goal is one page wide, one page tall, or one page total.

Set or expand the print area

In Excel for Microsoft 365 on Windows, select the cells you want included, then choose Page Layout > Print Area > Set Print Area. For example, if a report occupies A1:H42, select that range before setting it. Excel outlines the chosen area in the worksheet and prints that range rather than the whole sheet.

To include cells omitted by an existing print area, select the full intended range and choose Set Print Area again. This replaces the existing print area with the new selection. Alternatively, choose Page Layout > Print Area > Clear Print Area to remove the restriction, then set a new one if needed. Clearing the print area does not delete worksheet data or change the cells themselves.

Use Set Print Area when a specific table or report should print.
Use Clear Print Area when you want Excel to consider the worksheet’s used content instead.
Check for hidden rows or columns: they will not appear in the printed result while hidden.

If you select separate, nonadjacent ranges and set them as a print area, Excel can print the areas separately rather than assembling them into one continuous table. For a single-page report, a continuous rectangular selection is usually easier to control.

Fit the selected area onto one page

With the worksheet active, open the Page Layout tab and find the Scale to Fit group. Set Width to 1 page and Height to 1 page. Excel then scales the print area so it fits within one printed page, subject to the chosen paper size, orientation, and margins. To inspect the result, choose File > Print; the preview displays the page layout before printing.

Fitting both dimensions to one page is convenient for a compact summary, such as a 10-column monthly report with a few dozen rows. It can be a poor choice for a long ledger or a large dataset: Excel may shrink the text and columns until they technically fit but are difficult to read. The page count is not the only measure of success; check the actual preview at a useful viewing size.

If the worksheet is meant to span several pages vertically but should not split columns across pages, set Width to 1 page and leave Height as Automatic. This makes the report one page wide while allowing additional pages below it. Conversely, setting Height to 1 page and Width to Automatic keeps the content one page tall but may spread wide columns across pages. The best setting depends on how the reader will follow the information.

Choose between one page, one page wide, and a percentage

Use the Scale to Fit settings based on the document’s shape and purpose:

Width 1 page, Height 1 page: best for a short overview or form that must be a single sheet. It can make large worksheets unreadably small.
Width 1 page, Height Automatic: useful for a wide table that can continue down multiple pages without splitting its columns.
Width Automatic, Height Automatic: lets Excel paginate naturally. Use this when preserving a comfortable text size matters more than minimizing pages.

For more direct control, open the Page Setup dialog from the small dialog-box launcher in the lower-right corner of the Page Layout tab, then use the Page tab. The Adjust to option lets you specify a scaling percentage instead of fitting to a page count. A percentage can help when a sheet needs only a modest reduction, or when you intentionally want to enlarge a small printout. Excel’s scaling range is 10% to 400%; confirm the outcome in print preview rather than assuming a particular percentage will land exactly on the paper.

Adjust paper, orientation, and margins first

Before forcing a worksheet onto one page, check the physical layout. On Page Layout, choose the intended paper size under Size, select Portrait or Landscape under Orientation, and review Margins. Landscape often gives a wide table more room, while narrower margins can reclaim printable space. These changes may prevent an unnecessary reduction in scale.

The paper size in Excel should match the paper loaded in the printer or selected in the print settings. A mismatch can cause unexpected scaling or page breaks. Also remember that printers have nonprintable edges: choosing zero margins does not guarantee that every printer can place ink at the edge of the sheet. If the report still appears cramped, consider whether all columns need to print, whether a summary can be separated from detail, or whether a larger paper size is appropriate.

Check page breaks and repeated headings

Choose View > Page Break Preview to see how Excel divides the worksheet into printed pages. Blue lines mark page boundaries, and the preview can reveal a column pushed onto an otherwise nearly empty page. You can return to Normal view afterward. If you adjust page breaks, check print preview again because scaling, orientation, and paper size can affect where the breaks fall.

For a report that spans multiple pages, repeat its heading row so readers can identify columns on later pages. Choose Page Layout > Print Titles, then use the Rows to repeat at top field in the dialog to specify the heading row. For instance, a table with headings in row 1 can repeat that row on each printed page. This is more useful than squeezing a long table to one page if the smaller type would be hard to read.

Why the printout may not match expectations

Several settings can change what appears in the output. A defined print area can exclude newer rows, while hidden rows or columns can hide content from the printout. A manual page break can also divide a table where you did not expect. In File > Print, verify the selected printer, page range, paper size, and preview; printing the active sheet is different from printing the entire workbook or only selected cells.

Excel may also retain page-layout settings from earlier work. If the preview looks inexplicably tiny, check whether both Width and Height are set to 1 page or whether an unusually low percentage is selected in Page Setup. If only one column is missing, inspect the print area before changing scaling. Making the scale larger will not bring excluded cells into the print range.

On Excel for Mac, the same core concepts apply, but ribbon placement and dialog appearance can differ. Look for Print Area and Scale to Fit on the Page Layout tab, and use File > Print to preview. Excel for the web has printing and scaling options that may be more limited or presented differently; if a precise print layout is essential, open the workbook in the desktop app and review its Page Layout settings there.

A practical way to decide what to change

Suppose a sales report uses A1:J35, but the printout contains only columns A through H. First check whether the print area ends at H; if so, select A1:J35 and set it again. If all ten columns appear but the last two spill onto a second page, choose Landscape and set Width to 1 page. If the report then becomes too small, leave Height Automatic so rows can continue onto another page, or reduce unnecessary columns instead of shrinking the entire report.

For a compact dashboard that truly must fit on a single sheet, set both dimensions to 1 page and examine the preview. If labels are difficult to read, the correct fix may be a larger paper size, a different layout, or a shorter report—not further scaling. Before printing many copies, check the page count and inspect every page in preview; this catches blank pages and awkward splits without wasting paper.

Frequently Asked Questions

How do I print an Excel sheet on one page?
Choose Page Layout > Scale to Fit, then set Width and Height to 1 page. Use File > Print to check whether the result remains readable before printing.

How do I make Excel print more columns on one page?
Set Width to 1 page in Scale to Fit. Landscape orientation and suitable margins can also provide more horizontal room. If the text becomes too small, allow multiple pages vertically or simplify the printed range.

Why is Excel printing only part of my worksheet?
A print area may exclude the missing cells, or rows and columns may be hidden. Check Page Layout > Print Area and clear or reset it as needed, then inspect the preview.

Does setting the print area make the worksheet fit on one page?
No. Set Print Area chooses which cells print; scaling determines how those cells fit across pages. Set both separately when you need a specific range on a specific number of pages.

How do I remove an old print area?
Choose Page Layout > Print Area > Clear Print Area. This removes the print-range restriction, not the worksheet contents. Set a new area afterward if you want only part of the sheet printed.

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.