How to print only selected cells in Excel
In Excel for Windows, select the cells, press Ctrl+P, and choose Print Selection to print part of a worksheet once. To reuse the same range, set a print area on the Page Layout tab and save the workbook.
Print the current selection once
- Select the cells to include. For example, select A1:E6 if that contains the headers and data you need. Include any totals you want and leave out neighboring notes. If sheets are grouped, ungroup them and use only the intended sheet.
- Press Ctrl+P. In Settings, open the first dropdown for what to print and choose Print Selection. Check that the preview shows only A1:E6 in this example.
- Check the printer, paper size, orientation, and number of copies. If the preview has multiple pages, inspect the last page too before choosing Print.
Microsoft Support options for printing an Excel worksheet
Save the same print area for later
Select the cells and choose Page Layout > Print Area > Set Print Area. Save the workbook to keep that worksheet’s print area for future use.
To remove the area, choose Clear Print Area in the same menu. For one print job, choose Ignore Print Area in the print settings to keep the saved area while leaving it out of that job. Check that Print Active Sheets is selected if you want the active sheet.
Adding separate nonadjacent ranges creates print areas that print on separate pages. If you need the contents together on one page, select a single contiguous range and verify the preview.
Microsoft Support guide to setting and clearing a print area
Keep the rightmost columns on the page
Check landscape orientation and margins first. If you still need to fit a wide table, go to Page Layout and set the scaling width to 1 page and the height to Automatic. All columns fit across one page width while the rows can continue onto more pages.
Fitting everything onto one page can make the text too small. Check that headings and totals are readable. If expected data is missing, check the selected range, saved print area, hidden rows or columns, and active filters.
Microsoft Support guide to worksheet scaling
Save the selected range as a PDF
You can save the selection as a PDF for sharing or review. Choose the selection in the PDF options, then open the resulting file and confirm the page count and included cells.




