How to print ranges in Excel?

Typically, Microsoft Excel is set to print the entire worksheet, but there are times when you only need to print specific cell ranges to save paper and ink. This guide will walk you through the steps to selectively print multiple cell ranges in Excel, helping you focus on the data that matters most and reduce waste.

Print each selected range on separate pages with the Set Print Area command

Print multiple selected ranges into one page with Kutools for Excel

Print multiple selected ranges into one page with the Camera function

Print each selected range on separate pages with the Set Print Area command

In Microsoft Excel, we can set the print area to print only selected cell ranges in the active worksheet with the following steps:

1. Hold down the Ctrl key to select the non-contiguous ranges.

2. Click Page Layout > Print Area > Set Print Area, see screenshot:

3. Then the selected ranges will be surrounded by a dotted line, and then click File > Print to start printing the ranges one by one.

Notes:

1. This Set Print Area command only allows you to select and print cell ranges in the active worksheet. If you switch to another worksheet, the previous set of print areas will be cleared.

2. All selected non-contiguous print areas are separated with page breaks. Each range will be printed into one page, which may waste a lot of paper and printer ink.

3. If you need to add another cell range into the print area, you can select the cell ranges first, and then click the Add to Print Area command item. As well, you can release the selected ranges by clicking Clear Print Area. See the following screenshot:

Print multiple selected ranges into one page with Kutools for Excel

The Kutools for Excel provides us with the Print Multiple Selection Wizard tool, which will help us quickly print multiple ranges together. What's more, this tool makes it possible to set print ranges from different worksheets and helps us minimize print area greatly to save print paper and printer ink.

After installing Kutools for Excel, please do as following steps:

1. Click Kutools Plus > Printing > Print Multiple Selection Wizard, see screenshot:

2. In the Print Multiple Selection Wizard - Step 1 of 3 dialog box, click button to select the range that you want to print one by one after you have selected all the ranges you need, the ranges are listed in the list box, and you click button to remove the ranges you don’t need. See screenshots:

3. Click the Next button to go to step 2 of the wizard, specify the print settings as you need, you can use the Excel default settings, use the current worksheet settings or you can specify the new print settings that you want. Moreover, you can add a blank row between ranges by checking the Add a blank row between ranges option.

4. Go to step 3 of the wizard by clicking the Next button, and specify the action for the temporary worksheet:

• Active the worksheet, but don’t print it: If you check this option, the multiple selections will be copied and pasted to a new worksheet as a linked picture object, and the new worksheet will be active, but won’t be printed.
• Print the worksheet, and keep it: If you check this option, the new worksheet you created will be opened and printed at the same time.
• Print the worksheet, then delete it: If you check this option, the new worksheet you created will be printed and then will be deleted.

5. Click the Finish button, all of the ranges you selected have been pasted into a new worksheet as linked picture objects. And you can rearrange them in the worksheet. When you print, the ranges will be printed into one single page which can help you save the print paper and printer ink. See screenshot:

For more detailed information about the Print Multiple Selection Wizard feature, please visit the Print Multiple Selection Wizard feature.

Print multiple selected ranges into one page with the Camera function

With Excel’s Camera tool, you can take snapshots of multiple selected ranges. And you can place them on one page.

By default, the Camera tool is not present on the ribbon, you need to add it on the Excel Quick Access Toolbar, please do as follows:

1. Go to the Quick Access Toolbar and from the small drop-down button, click More Commands.

2. In the Excel Options dialog box, under the Choose commands from drop-down list, select All Commands, and then scroll down to find Camera, select it, and click the Add>> button, the camera has been added to the right list box, see screenshot:

3. Then click OK, the camera button has been inserted on the Quick Access Toolbar, see screenshot:

Then you can use the camera tool to take snapshots of the selected ranges.

1. Select the range that you want to take a picture of.

2. Click the Camera tool. The mouse pointer changes to a thin plus sign.

3. Change to a different worksheet you want to put the range and click where you want the top left-hand corner of the picture to appear. The picture is inserted as a graphic on the worksheet.

4. Then repeat the above steps to put the ranges into the worksheet as graphics, and you can resize them as you need. See screenshot:

5. And then you can click File > Print to print the selected ranges into one page.

Note: The pictures are dynamic, meaning that if the contents of the original ranges are changed, the values in the picture are changed as well.

Related articles:

Print multiple workbooks in Excel

Quickly print current page in Excel

Print long column on one page in Excel

Copy Excel page setup to other worksheets