Excel Print Selected Area on One Page: Steps & Tips

To print a selected area on one page in Excel for Microsoft 365 on Windows, select the cells, then choose File > Print and select Print Selection under Settings. Open the scaling menu and choose Fit Sheet on One Page. To save a reusable print range, set it with Page Layout > Print Area > Set Print Area, then set Width and Height to 1 page in the Scale to Fit group.

Choose between printing a selection and setting a print area

Excel offers two related ways to limit what prints. Print Selection is a one-time choice made in the Print screen; it is useful when you need a quick printout of a few cells and do not want to change the worksheet’s saved print settings. A print area is a range stored with the worksheet. It is a better choice for a report you print repeatedly, because Excel remembers which cells belong in the output.

For a saved print area, select the contiguous cell range you want, such as A1:H35, and choose Page Layout > Print Area > Set Print Area. Then choose 1 page for both Width and Height in the Scale to Fit group. Check the result in File > Print before printing. If you set the area but do not adjust scaling, it may still span several pages.

These controls solve separate problems: the print area says what to include, while scaling says how to fit that content onto paper. Setting one does not automatically guarantee the other. The distinction matters in a wide table, where the rightmost columns can otherwise spill onto a second page, or in a long report, where rows may continue onto additional pages.

Step-by-step: print selected cells immediately

On the worksheet, drag across the cells you want to print. Include any headings or labels that should appear with the data.
Choose File > Print. Under Settings, open the print-range menu (it may initially say Print Active Sheets) and choose Print Selection.
Open the scaling menu, which may initially say No Scaling, and select Fit Sheet on One Page.
Review the preview, check the printer and paper settings, then choose Print.

The preview is important: it shows the selected cells as a page, not just as they appear on the worksheet. If Excel displays blank pages or tiny content, go back and check the selection, orientation, margins, and scaling. Selecting cells before opening the Print screen is essential; otherwise Print Selection may be unavailable or may not represent the range you intended.

In the print screen, Fit Sheet on One Page applies to the content being printed. When Print Selection is chosen, that content is the selected range. When Print Active Sheets is chosen, it is the active sheet or sheets instead. Confirm the setting shown in the preview before sending a multi-page workbook to a printer.

Save and scale a print area for repeat use

To keep a range as the worksheet’s print area, select it and choose Page Layout > Print Area > Set Print Area. Excel marks the range as printable; cells outside it are excluded from normal printing of that sheet. With the range still active, use Page Layout > Scale to Fit and set Width to 1 page and Height to 1 page. These settings tell Excel to shrink the print area as needed so it occupies a single page.

You can also open the Page Setup dialog from the Page Layout tab using the small dialog box launcher in the Page Setup group. On its Page tab, select Fit to and enter 1 page wide by 1 tall. This is an alternative to the Scale to Fit controls, not a second scaling step. If Fit to is selected, Excel calculates the scale to meet those page limits; a manually entered percentage is not the controlling setting.

To remove a saved area, choose Page Layout > Print Area > Clear Print Area. To replace it, select the new range and use Set Print Area again. Print areas are worksheet-specific, so a range set on one sheet does not automatically apply to another. If you print several sheets, review each sheet’s print range and page setup individually.

Make the page readable before shrinking it

Fit to one page is a constraint, not a promise of legible type. If a report contains many rows and columns, Excel can reduce the entire range substantially. The preview may technically show one page while the printed text is too small to read comfortably. Rather than accepting that result, consider whether the report can be reorganized or whether multiple pages would serve the reader better.

For a wide table, try Landscape orientation: Page Layout > Orientation > Landscape. It gives the columns more horizontal room.
Choose a suitable paper size under Page Layout > Size, taking care that it matches the paper loaded in the printer.
Reduce excess whitespace with Page Layout > Margins. Narrow margins can help, but the printer may not be able to print to the very edge of the sheet.
Remove unnecessary columns or rows from the print area, or shorten overly wide column headings if doing so preserves meaning.
Use a larger paper size only if the printer supports it and the intended reader can use that paper.

For example, a table with six columns and twenty rows may fit on one portrait page at a readable size. A sheet with thirty columns and hundreds of rows is a different case: fitting everything onto one page can make the content impractical to read. In that situation, printing one page wide and several pages tall, or splitting the report into meaningful sections, is often more useful than forcing both dimensions to one page.

Understand the trade-off between one page and multiple pages

Excel’s Fit Sheet on One Page option prioritizes the page limit. It does not decide which information is important, enlarge the paper automatically, or redesign the worksheet. The more content in the selected range, the more it may have to shrink. This is why print preview should be treated as a layout check rather than as a final cosmetic step.

If the main issue is width, choose Fit All Columns on One Page instead of Fit Sheet on One Page. This keeps the columns together horizontally but can allow the rows to continue over multiple pages. If the issue is length, Fit All Rows on One Page can keep the rows together vertically while allowing pages across the width. The exact labels appear in the Print screen’s scaling menu. These choices often preserve readable text better than forcing both width and height to one page.

Another option is to allow multiple pages and repeat column headings. In Page Layout, choose Print Titles and set rows to repeat at the top of each page. That makes a long table easier to follow when it continues onto another sheet of paper. Repeating headings does not reduce the number of pages, but it can make a multi-page printout more useful.

Check print areas, page breaks, and blank pages

Old print settings can explain surprising output. A saved print area may exclude new rows added to a report, or it may include unused columns that force Excel to shrink everything. If the wrong cells appear, select the intended range and set the print area again, or clear the old area before starting over. Then return to Print Preview to confirm that the intended content is included.

Nonadjacent selections need special attention. If you select separate blocks using Ctrl and set them as print areas, Excel treats multiple print areas as separate printable regions; they may print on separate pages rather than being combined into one continuous rectangle. For a single page containing all the data, it is usually simpler to place the blocks together in one contiguous range or copy the required material to a report sheet.

Page breaks can also make the worksheet view seem different from the printed result. Excel has automatic page breaks and supports manual page breaks, but fitting a sheet to one page changes the scale to meet the fit setting. If the preview still seems wrong, switch to View > Page Break Preview to inspect the page boundaries, then return to Page Layout or Print to adjust the setup. Avoid relying on the worksheet grid alone to predict the paper layout.

Windows, Mac, and Excel for the web

The instructions above use Excel for Microsoft 365 on Windows. In Excel for Microsoft 365 on Mac, the same core ideas apply: select cells, open the print controls to print a selection, or use the Page Layout tab to define a print area and fit it to a page. Ribbon placement and the print dialog can look different on Mac, so use the displayed print-range and scaling controls rather than expecting every Windows dialog to match exactly. The Mac keyboard equivalent for Ctrl-based selection is generally Command-click for separate cells or ranges; dragging works for a contiguous range on either platform.

Excel for the web has a different print interface and may not expose every desktop page-setup control in the same place. If you cannot find the saved print-area or scaling options needed for precise one-page output, open the workbook in the desktop Excel app and use Page Layout and Print Preview there. Regardless of platform, review the actual preview because printer defaults, paper size, and margins affect the final page.

Frequently Asked Questions

How do I print only selected cells in Excel?
Select the cells, choose File > Print, and select Print Selection under Settings. Check the preview to make sure the range is correct. This is convenient for a one-time print; use Set Print Area if you want the worksheet to remember the range.

Why is my Excel printout still on more than one page?
The print range may not be set to fit, or you may have chosen a scaling option that fits only the columns or rows. In the Print screen, choose Fit Sheet on One Page, or set Width and Height to 1 page in Page Layout > Scale to Fit. Also check whether the selection or print area includes extra cells.

How can I fit all columns on one page without shrinking every row?
In File > Print, choose Fit All Columns on One Page from the scaling menu. Excel can then continue the rows onto additional pages. This is often preferable for long tables because it keeps the columns together without forcing the full height onto one sheet.

Will fitting an Excel sheet to one page make the text smaller?
Usually, if the selected content is larger than the printable page area. Excel reduces the scale to fit; the amount depends on the range, paper size, orientation, and margins. Review the preview and choose multiple pages or simplify the print range if the result is too small to read.

How do I remove a print area in Excel?
Go to the worksheet and choose Page Layout > Print Area > Clear Print Area. If you are printing a selection from the Print screen, that one-time choice does not require a saved print area. Clear or reset the area when the worksheet’s regular print output should include a different range.

A practical final check

Before printing, verify three things in the preview: the correct cells are included, the page count is what you expect, and the text is readable at the displayed size. Then check orientation, paper size, and margins if the layout is cramped. For a quick partial print, use Print Selection; for a repeatable report, save a print area. Choose a one-page fit only when the resulting scale remains useful to the person reading the paper copy.

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.