How to Print a Selected Area in Excel on One Page Only

How-to basics · Updated November 21, 2026

To print only part of a worksheet in Excel for Microsoft 365 on Windows, select the cells you want, then choose File > Print and change the print settings dropdown to Print Selection. Check the preview before printing. If you will print the same range again, set it as a print area instead; that saves the range in the workbook.

What You’ll Need

  • An Excel workbook with the data or cells you want to print.
  • A printer connected to your computer, or access to a PDF option such as Microsoft Print to PDF.
  • A rough idea of the paper size and orientation you want. You can adjust these in the print settings if the selected area does not fit neatly.

Step-by-Step

  1. Select the cells. Open the worksheet and select the exact rectangular range to print. Click the first cell and drag to the last, or click the first cell, hold Shift, and click the last cell. To select a whole column or row, click its letter or number, but remember that printing an entire column or row can include far more blank space than intended. If you need to select a large range, click its first cell, hold Shift, and click the last cell, or type the range address, such as A1:F25, in the Name Box to the left of the formula bar and press Enter.
  2. Open the print screen. Choose File > Print, or press Ctrl+P on Windows. Excel opens Print Preview and displays the printer and print settings. Confirm the correct worksheet and printer are shown before continuing.
  3. Choose Print Selection. Under Settings, open the dropdown that usually reads Print Active Sheets. Choose Print Selection. This tells Excel to print the cells currently selected, rather than the whole worksheet or workbook. If you do not see the option immediately, open the Settings dropdown and review the full list.
  4. Review the preview. Look at every preview page, not just the first. Confirm that the first and last rows and columns you need are present, and that no unwanted cells appear. If the preview is blank or incomplete, return to the worksheet and check that the intended cells are selected, then reopen File > Print and select Print Selection again.
  5. Adjust the page layout if needed. In the print settings, choose the paper size, orientation, and margins that suit the selected cells. Portrait is useful for a narrow, tall range; Landscape often suits a wide table. Under scaling, choose an option such as Fit All Columns on One Page if you need the columns to stay together. Check the preview again because shrinking a range to one page can make text too small to read.
  6. Print or save a PDF. When the preview looks right, click Print. To create a file instead, select Microsoft Print to PDF as the printer on Windows, then click Print and choose a file name and location. PDF output is useful for checking the result or sharing a fixed copy without using paper.

For a range you print repeatedly: select the cells, then choose Page Layout > Print Area > Set Print Area. After that, File > Print can print the defined area without requiring you to select it each time. The print area is saved with the workbook. To remove it later, choose Page Layout > Print Area > Clear Print Area.

In Excel for Mac, select the cells and use File > Print; choose the selection or selected-cells option in the print dialog if it is available in your build. The wording and layout can differ from Windows. Setting a saved range through Page Layout > Print Area > Set Print Area is another practical approach when that command is available. In Excel for the web, use File > Print and inspect the available selection or sheet options; if the browser version does not offer printing the selection directly, set up the range in the desktop app or copy it to a new sheet before printing.

Common Mistakes

  • Choosing the wrong print setting. Selecting Print Active Sheets prints the current worksheet, not just the highlighted cells. For a one-time print, explicitly choose Print Selection. For repeated printing, set a print area and preview the result.
  • Assuming highlighting means the range is saved. A selection is temporary: when you click elsewhere, it changes. A print area is a saved worksheet setting. Use the option that fits your task, and remember that an existing print area can affect later print jobs.
  • Including stray cells. A click or drag beyond the intended table can add extra rows or columns. Return to the sheet, inspect the highlighted boundary, and select only the cells required. Also check for merged cells near the edge, which can make the printed layout less predictable.
  • Printing without checking page breaks. Excel may split a wide or long selection across several pages. The preview shows where pages divide. If a row or column is cut awkwardly, try Landscape, narrower margins, or a suitable scaling choice, then review all preview pages again.
  • Making everything fit at any cost. Fit Sheet on One Page can reduce a large range until the text is difficult to read. Prefer Fit All Columns on One Page when the main problem is width, or print on more pages if readability matters more than page count.
  • Expecting formatting to be included automatically. Excel prints cell contents and applicable formatting, but a worksheet may have print settings, hidden rows or columns, or objects that change the output. Check the preview for missing content, unexpected colors, clipped text, or unwanted blank space.

Tips

  • Use a temporary selection for a one-off job. Print Selection is usually the quickest method when you need a few cells once and do not want to change the worksheet’s saved print setup.
  • Use a print area for a recurring report. A defined print area is helpful for a monthly summary or a standard form. Before printing, confirm that the area still includes new rows or columns added since it was set; Excel does not always expand a saved print area to include later data.
  • Consider the reading order. For a wide table, Landscape can avoid splitting columns. For a narrow report with many rows, Portrait may be easier to read. Choose orientation based on the content, then inspect how Excel paginates it.
  • Use scaling selectively. Fit All Columns on One Page can keep a table’s columns together while allowing rows to continue onto later pages. If both width and height must fit on one page, Fit Sheet on One Page is available, but it can reduce the print size substantially.
  • Check print titles for multi-page tables. If a long table spans pages and you want its headings repeated, use Page Layout > Print Titles to set rows or columns to repeat. This is separate from selecting a print area, and the repeated headings can make later pages easier to understand.
  • Keep the worksheet intact. You do not need to delete or hide surrounding data to print a selection. Choosing Print Selection or setting a print area controls the output without removing other worksheet content.
  • Use Print Preview as the final check. A range can look tidy on screen but print differently because of paper size, margins, scaling, or printer defaults. Preview is the quickest way to catch extra pages, cropped edges, or text that has become too small.

Troubleshooting

The whole worksheet prints instead of the selected cells. Re-select the range in the worksheet, open File > Print, and check that Settings says Print Selection rather than Print Active Sheets. If you are using a saved print area, choose Print Active Sheets and verify that the correct area is defined with Page Layout > Print Area. Clear an old print area and set it again if it points to the wrong cells.

The preview shows a blank page or the wrong range. Close the print screen, return to the worksheet, and confirm the selection boundary. A copied range is not necessarily the active selection you intend to print. Select the cells again, then open File > Print. Also check that the correct worksheet tab is active and that no unexpected filter or hidden rows are changing what is visible.

Some columns or rows are missing. Look through every preview page; the missing content may have moved to a second page. If it is clipped, change orientation, paper size, or margins. You can also use a scaling option to fit the columns across a page. Avoid reducing the whole range until you have checked whether a landscape page or slightly wider margins solve the problem without making the text unreadable.

The range prints on too many pages. In File > Print, examine the scaling options. Fit All Columns on One Page can reduce the number of pages across, while allowing the range to continue down multiple pages. Fit Sheet on One Page constrains both directions and may be suitable for a small selection. If the range is large, using more pages can be clearer than shrinking it to an unreadable size.

The print area is not being used. A print area applies to its worksheet, not every sheet in the workbook. Confirm the correct sheet is active, then check Page Layout > Print Area. If needed, choose Clear Print Area and set the desired range again. For a single print that should ignore a saved area, select the new cells and choose Print Selection in the print settings.

The output looks different from the preview. Check the selected printer, paper size, and orientation in Excel and in the printer’s own settings. A printer may substitute a different paper size or have non-printable margins. Saving to PDF is a useful way to separate Excel’s page layout from printer hardware; if the PDF looks right but paper output does not, review the printer settings.

Frequently Asked Questions

Can I print only a selected area in Excel without setting a print area?
Yes. Select the cells, choose File > Print, and select Print Selection under Settings. This is best for a one-time print because it does not save a recurring range in the worksheet.

What is the difference between Print Selection and Set Print Area?
Print Selection prints the cells selected at that moment. Set Print Area saves a specific range for the worksheet so it can be used again. A saved print area may need updating if the report grows.

Can I print non-adjacent cells?
You can select separate ranges by holding Ctrl while selecting additional cells on Windows, but the resulting layout may be split into separate print areas or pages and may not look like one continuous table. For a clean result, copy the needed cells to a temporary worksheet, arrange them together, and print that range.

How do I print the selection on one page?
Choose Print Selection, then use the scaling dropdown in File > Print and select Fit Sheet on One Page. Review the preview and check the text size. If it is too small, use landscape orientation or allow the selection to span multiple pages.

Does changing the print area delete cells outside it?
No. A print area controls what Excel includes in a print job; it does not delete or alter other worksheet data. Clear the print area when you want to return to printing a different range or the whole sheet.

Can I print a selected area from Excel for the web?
Options vary by the web version and print interface. Check File > Print for a selection option. If it is not offered, open the workbook in desktop Excel and print the selection there, or copy the required cells to a separate sheet and print that sheet.

Related

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.