How to Print Just a Highlighted Area in Excel

How-to basics · Updated November 21, 2026

To print only part of an Excel worksheet, select the cells you want, then choose Page Layout > Print Area > Set Print Area. For a one-time print, use File > Print and choose Print Selection instead. Excel will print the chosen cells rather than the whole sheet. Here, “highlighted area” means the selected cell range; a colored fill by itself does not tell Excel what to print.

What You’ll Need

  • An Excel workbook with the cells you want to print.
  • A printer connected to your computer, or access to a way to save or preview the printout, such as Microsoft Print to PDF.
  • Microsoft Excel for Microsoft 365 on Windows for the menu paths below. Excel for Mac has similar print-area commands, though the dialog layout can differ.

Step-by-Step

  1. Open the worksheet and identify the exact range. Find the top-left and bottom-right cells you want on paper. For example, if the report occupies cells B2 through F18, the range is B2:F18. Include headings, notes, and totals if they need to appear in the printout. Selecting a range does not change the workbook’s data.
  2. Select the cells to print. Click the first cell, hold the left mouse button, and drag to the last cell. Alternatively, click the Name Box to the left of the formula bar, type the range (for example, B2:F18), and press Enter. Excel selects that range. Check the outline around the selection before continuing; a small selection error can omit a row or column from the output.
  3. Choose whether this is a one-time print or a saved print area. For a single print, leave the range selected and go to File > Print. In the Settings list, open the option that normally says Print Active Sheets and choose Print Selection. For a range you expect to print repeatedly, use the saved print-area method in the next step instead. Avoid setting both methods unnecessarily: the print settings and saved area can make it harder to tell which range Excel is using.
  4. Set a print area for repeat printing. With the intended cells still selected, choose Page Layout > Print Area > Set Print Area. Excel marks the selected range as the print area for that worksheet. The range is saved with the workbook, so later choosing Print Active Sheets prints that area rather than every used cell on the sheet. This setting applies to the active worksheet, not automatically to every sheet in the workbook.
  5. Check the print preview. Choose File > Print to view the preview before sending the job. Confirm that the correct cells appear, that headings and totals are present, and that no important text is cut off. Use the page navigation controls if the range spans more than one page. If the preview shows the whole sheet, check whether the print setting is Print Active Sheets or whether a saved print area is active.
  6. Choose paper and layout settings. In the print screen, check the selected printer, paper size, orientation, and margins. A wide range may fit better in landscape orientation; a tall range may work better in portrait. If the range is just slightly too large, use the scaling option in the print settings, such as Fit All Columns on One Page. Review the preview again: fitting everything onto one page can shrink text until it is difficult to read.
  7. Print or save the output. When the preview looks right, choose the printer and click Print. To create a PDF instead, select Microsoft Print to PDF as the printer, click Print, then choose a file name and location in the save dialog. This is useful for checking the final page or sharing it without sending a physical print job.
  8. Clear or update the print area when the range changes. To replace a saved area, select the new cells and choose Page Layout > Print Area > Set Print Area again. To remove the saved setting, choose Page Layout > Print Area > Clear Print Area. Then preview the sheet again. Clearing the print area does not erase worksheet data or formatting; it only removes the saved instruction about what to print.

On Excel for Mac, select the range and use Page Layout > Print Area > Set Print Area if that command is available in your ribbon layout, then check File > Print. For a one-time print, select the cells and inspect the print dialog for the selection option; dialog labels and arrangement can vary by Excel version. The Windows print-screen steps above are for the desktop app, not a browser-based print dialog.

Common Mistakes

  • Assuming cell color defines the print range. A yellow-filled cell or a colored selection outline is not a print instruction. Excel prints based on a selected range or a saved print area. If by “highlighted” you mean cells with a particular fill color, Excel does not automatically print only those cells because of that color. Select the desired cells manually or copy the relevant records to a separate print sheet.
  • Choosing the wrong print setting. Print Active Sheets and Print Selection are different. The first prints the active sheet’s print area, if one exists; the second prints the currently selected cells. If the selection option is not chosen for a one-time print, Excel may print more than you intended.
  • Forgetting that a print area stays in the workbook. After setting one, Excel can keep using it on later print jobs. If a future preview leaves out new rows, the old print area may still be in effect. Update it or clear it before printing the expanded report.
  • Trying to print a selection that is too small or too large. Accidentally omitting a title row is easy when dragging through a large worksheet. Conversely, including entire worksheet columns can create many blank pages. Select only the needed cell range and inspect every preview page.
  • Expecting worksheet gridlines or screen colors to look identical on paper. Gridlines may not print by default, and screen colors can appear differently on a printer. Use cell borders when clear table lines matter. For gridlines, check Page Layout > Sheet Options > Gridlines > Print, then preview the result.

Tips

  • Use Print Selection for an occasional extract. It is quick and does not require leaving a saved print area behind. Before opening the print screen, click the range again if you have changed worksheets or clicked elsewhere.
  • Use Set Print Area for a standard report. This is convenient when the same block is printed regularly. If the report grows, reset the print area to include the added rows or columns. A saved print area belongs to a worksheet, so check each sheet you plan to print.
  • Use the Name Box for precise ranges. Typing B2:F18 is often more reliable than dragging across a long table. The Name Box is above the worksheet, to the left of the formula bar. After pressing Enter, verify the selection before using the print command.
  • Make print size readable. Changing orientation or margins can be better than shrinking a wide table to one page. If fitting all columns on one page makes the font tiny, allow the table to span multiple pages or adjust the worksheet layout instead.
  • Keep a copy of the source data in mind. A print area only controls the printed output; it does not hide, delete, or protect the other worksheet cells. Check the preview for sensitive information near the selected range, especially if the printout will be shared.
  • Print separate blocks deliberately. If the cells you want are not next to one another, selecting multiple ranges with Ctrl-click may be possible, but the output can be split into separate print areas or pages. For a predictable report, it is often clearer to arrange the needed blocks together on a dedicated worksheet and print one rectangular range.

Troubleshooting

  • The preview shows the entire worksheet. If you meant to print just the current selection, return to File > Print, open the Settings list, and select Print Selection. If you intended to use a saved area, select Print Active Sheets and confirm the correct sheet is active. You can also reset the range with Page Layout > Print Area > Set Print Area.
  • The preview is blank or missing cells. Check that the correct worksheet is active and that the desired cells are included in the selection or saved area. Look for hidden rows or columns, filters, and a stale print area. Clear the print area, select the intended range again, and preview. If filtered rows are hidden, they generally will not appear in the printout.
  • The range spills over too many pages. Open the print settings and try landscape orientation, narrower margins, or a scaling option such as Fit All Columns on One Page. Avoid forcing a very large table onto one page if the resulting text is unreadable. Use the preview’s page controls to see where Excel divides the output.
  • Text or borders are missing. Increase column width or row height, turn on wrapping where appropriate, and use cell borders if gridlines are not printing. Check the preview after each change. If color or shading is essential, confirm that the printer supports color and that color printing is enabled in its properties.
  • You cannot find Print Selection. Confirm that cells are selected before opening the desktop app’s print screen, then expand the Settings list. Excel for the web and some Mac versions may display print controls differently. If the option is unavailable, use the desktop Excel app to set a print area, or copy the range to a separate worksheet and print that sheet.

Frequently Asked Questions

Does Excel print only the cells I highlighted with my mouse?
Not automatically in every print mode. Select the cells, then choose File > Print > Print Selection, or set them as a saved print area. The selection outline itself is not printed as a colored highlight.

Will a cell’s fill color make Excel print only that cell?
No. Fill color is formatting, not a print-range rule. Select the cells you want to print, regardless of their color. If you need to isolate cells based on color, first gather them into a suitable range or separate worksheet.

How do I print the same selected area again later?
Select it and choose Page Layout > Print Area > Set Print Area. Save the workbook to retain the setting. When printing that sheet later, use Print Active Sheets and check the preview.

How do I go back to printing the whole sheet?
Choose Page Layout > Print Area > Clear Print Area. Then open File > Print and check the preview. If you only used Print Selection, change the print setting back to Print Active Sheets.

Can I fit the selected area onto one page?
Yes. In the print settings, choose a scaling option such as Fit Sheet on One Page or Fit All Columns on One Page, depending on what is available. Preview the result and avoid scaling so far down that the text becomes hard to read.

Will Excel print hidden rows within the selected range?
Hidden rows and columns normally do not appear in a printout. Unhide the data you need before printing, or check the preview to confirm that the visible output contains the intended information.

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.