How to Print Selection in Excel (Windows, Mac and Web)

Last updated on November 9th, 2026 at 01:19 pm

To print only part of a worksheet in Excel, select the cells you want, press Ctrl + P (or choose File > Print), and under Settings change the first drop-down from Print Active Sheets to Print Selection. The preview on the right shrinks to just your cells, and you select Print. If you print the same range every week, set a print area instead so Excel remembers it. If the printout has no cell borders, you can print gridlines in Excel from the Page Layout tab.

Applies to: Excel for Microsoft 365, Excel 2024, Excel 2021, Excel 2019 and Excel 2016 on Windows, plus separate steps below for Excel for Mac and Excel for the web. The menu names match Microsoft’s Print a worksheet or workbook page.

Print Selection or print area: which one you need

Excel gives you two ways to print part of a sheet, and they behave differently.

  • Print Selection is a one-time choice. It prints whatever cells are highlighted right now and forgets about them afterward. Use it for a quick printout of a few rows, a single table, or a section you need for a meeting.
  • A print area is saved with the workbook. Every time anyone prints that sheet, Excel prints only that range until the print area is cleared. Use it for a report, invoice or schedule you print the same way over and over.

By default Excel prints everything on the sheet that contains data, so without one of these, you get the whole worksheet.

Print a selection in Excel for Windows

  1. Select the cells. Click the first cell and drag to the last one, or click the first cell, hold Shift and click the last one. Include the header row and any totals you want on paper. For example, if Priya’s sales list runs from A1 to E40 but she only needs January, she would select A1:E12.
Excel worksheet with cells A1 through E12 of a sales list selected
Select A1:E12, including the headings and the eleven January sales rows. The fictional forty-row list continues with February below the selection; only January is highlighted. Cell borders were added to this sample.
  1. Open the Print screen. Press Ctrl + P, or select File in the top-left corner and then Print. The print settings appear on the left and a preview on the right.
  2. Change what gets printed. Under Settings, select the first drop-down. It normally reads Print Active Sheets. Choose Print Selection.
Excel Print screen with the Settings drop-down open and Print Selection highlighted
Open the first Settings menu and choose Print Selection. The recreated menu shows the shared Windows Excel options for a plain cell range. Microsoft Print to PDF is an illustrative printer choice; no job was submitted.
  1. Check the preview. The preview should now show only the cells you selected, and the page count at the bottom should drop. If you still see the whole sheet, go back and redo step 1 (see Troubleshooting).
Excel print preview showing only the selected sales range on one page
The preview contains the A1:E12 headings and January rows only, with one page at No Scaling. February rows and worksheet row/column labels are excluded. This recreated preview uses the same bordered sample data and does not represent a print job.
  1. Pick the printer and copies. Choose your printer under Printer and set the number of Copies at the top.
  2. Select Print. Only the highlighted cells print.

Don’t click on the worksheet between steps 1 and 3. A single click selects one cell, and Excel then prints only that cell.

Rows and columns you’ve hidden stay off the printout too. Microsoft notes that pages containing only hidden rows or columns aren’t printed. If you filtered a list, the filtered-out rows won’t appear on paper either. To copy that visible-only data somewhere else instead, see selecting only visible cells in Excel. Hidden charts are left off the printout too, so unhide the chart in Excel before you print if it should appear on the page.

Print two or more separate ranges

You can print blocks of cells that aren’t next to each other in one job.

  1. Select the first range.
  2. Hold Ctrl and select each additional range.
  3. Press Ctrl + P and choose Print Selection.

Each range prints on its own page. Excel won’t put separate ranges side by side on one sheet of paper. If you need them together, copy them next to each other on a new worksheet and print that, or paste them as a linked picture.

Make the printed selection fit and read well

The Print screen has its own settings below the selection drop-down, and they apply to this print job. Work through them in this order, because the first ones keep text readable:

  1. Orientation: switch Portrait Orientation to Landscape Orientation if the selection is wider than it is tall.
  2. Margins: choose Narrow Margins to gain a little space on each side.
  3. Scaling: change No Scaling to Fit Sheet on One Page, or to Fit All Columns on One Page for long lists. The second option keeps the width on one page and lets rows continue onto more pages, which is usually easier to read.

Microsoft’s Scale a worksheet page points out two catches: Excel ignores manual page breaks when you use a Fit to option, and it doesn’t stretch small data to fill the page. Heavy shrinking also makes text tiny. If a small selection prints in one corner, stretching the spreadsheet to fill the printed page covers the percentage scaling that enlarges it. To place it in the middle of the paper, center the page horizontally from Page Setup.

Two more settings live on the Page Layout tab rather than the Print screen:

  • Repeat the header row on every page. Select Page Layout > Print Titles, and on the Sheet tab type the row in Rows to repeat at top (for example, $1:$1). The steps are on Microsoft’s repeat rows or columns on every printed page page.
  • Print the cell grid. Gridlines don’t print by default. Under Sheet Options, check Print under Gridlines. They print only around cells that contain data, so add borders if you need lines around empty cells.

A print area saves you from reselecting the same cells each time.

  1. Select the cells you want to print.
  2. Select Page Layout > Print Area (in the Page Setup group) > Set Print Area. A thin gray line appears around the range.
Excel Page Layout tab with the Print Area menu open and Set Print Area highlighted
With A1:E12 still selected, choose Page Layout > Print Area > Set Print Area. The recreated shared menu saves a reusable range when the workbook is saved; no print area was actually applied.
  1. Save the workbook. The print area is saved with it.
  2. Press Ctrl + P. The first drop-down can stay on Print Active Sheets; the preview shows only the print area.

To include more cells later, select them and choose Print Area > Add to Print Area. According to Microsoft’s Set or clear a print area page, only cells next to the existing area join it; cells elsewhere become a separate print area that prints on its own page. If a large grey page label shows up while you check the print area, see how to remove the Page 1 watermark in Excel, which doesn’t print.

Undo it: click anywhere on the sheet and choose Page Layout > Print Area > Clear Print Area. If the sheet has several print areas, this removes all of them. To ignore the print area for just one job, open the Settings drop-down on the Print screen and select Ignore Print Area so it shows a check mark.

To see exactly what each page will hold, select View > Page Break Preview and drag the blue borders. Pages that break in odd places are covered in removing page breaks in Excel.

Print a selection in Excel for Mac

Microsoft’s Print part of a sheet in Excel for Mac page covers Excel for Microsoft 365 for Mac, Excel 2024 and Excel 2021.

  1. Select the cells. Hold Command to add a second range.
  2. Choose File > Print from the menu bar, or press Command + P.
  3. In the Print dialog, open the drop-down that controls what prints and choose Selection.
  4. Check the preview, then click Print.

On a Mac, the print area commands are in the menu bar: File > Print Area > Set Print Area or Clear Print Area.

Print a selection in Excel for the web

  1. Open the workbook in your browser and drag across the cells you want.
  2. Select File > Print > Print.
  3. In Print Options, choose Current Selection.
  4. If the preview looks right, select Print. Your browser’s print window then opens, where you pick the printer.

The web version is more limited. Microsoft says multiple print areas need the desktop app, which you can open with Open in Desktop App from the Editing menu.

Save the selection as a PDF instead

To send the selected cells to someone without printing, follow the Windows steps above but choose Microsoft Print to PDF under Printer. When you select Print, Windows asks where to save the file. On a Mac, use the PDF menu in the Print dialog and choose Save as PDF.

You can also use File > Save As, pick PDF as the file type, select Options, and choose what to include under Publish what. The PDF uses the sheet’s paper size, so change the paper size in Excel first if the recipient prints on A4 or legal paper.

The whole sheet still prints

The whole sheet still prints

The drop-down went back to Print Active Sheets, or the selection changed. Excel doesn’t keep Print Selection between jobs. Close the Print screen, select the range again, press Ctrl + P and pick Print Selection right away.

Only part of what I selected prints, or something else prints

A print area from an earlier job is probably set. Check for a gray outline on the sheet. Clear it from Page Layout > Print Area, or turn on Ignore Print Area in the Settings drop-down.

Blank or extra pages come out

Microsoft’s article on blank pages printed unexpectedly lists the usual causes: cells formatted to look empty (white text, for example), small or white drawing objects far from your data, and hidden columns with manual page breaks. Printing a selection avoids most of these, because nothing outside it prints. For a whole sheet, enter the page numbers you need in the Pages boxes on the Print screen.

Print Titles or Print Area is grayed out

Press Esc if you’re still typing in a cell. Microsoft also lists a selected chart and having no printer installed as reasons Print Titles is dimmed. If several sheet tabs are selected (the title bar shows Group), right-click a tab and choose Ungroup Sheets.

Gridlines don’t show on paper

Check Print under Gridlines on the Page Layout tab, and make sure Draft quality is cleared on the Sheet tab of Page Setup.

Will comments and notes print with the selection?

Not unless you turn them on in Page Setup on the Sheet tab. Threaded comments can print only at the end of the sheet; how to add and print them is covered in inserting a comment in Excel.