Print a Selection of Cells in Excel 2013

Last updated on May 15th, 2023 at 08:13 pm

An Excel spreadsheet can contain a lot of information. Maybe you are working on a downloaded copy of a database, or a large order that a customer has sent to you. You might need all of the information contained in that spreadsheet, but it’s likely that you do not need all of it in every situation. So if you need to print a report based on that spreadsheet, you might want to restrict it to just a few columns or a group of cell.

Fortunately you can make a selection in your spreadsheet, then only print that selection. This allows you to keep all of the information contained within the spreadsheet, but only print what you actually need. So follow our guide below to learn how to configure your spreadsheet to print this way.


How to Print a Selection in Excel 2013

The steps in this article will have you selecting a group of cells, then adjusting the print settings so that only that selection is printed. The rest of the cells in your spreadsheet will not be printed when you follow the steps below.


Step 1: Open your spreadsheet in Excel 2013.


Step 2: Select the group of cells that you want to print.

make the selection that you want to print



Step 3: Click the File tab at the top-left corner of the window.

click the file tab



Step 3: Click Print in the column at the left side of the window.

click print in the left column



Step 4: Click the Print Active Sheets button, then click Print Selection. You will notice that the Print Preview will adjust to only display the cells that you selected in Step 2.

click the print selection option



Step 5: Click the Print button.

click the print button



If you’re printing a multi-page document, then it’s helpful to print the top row on every page. This will make it much easier for your spreadsheet readers to know what column a cell belongs to.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy

Newest Guides