✦Template Printable Ideas Insights

Print Specific Range in Excel: Select & Print

By

When you need to print only a specific section of your worksheet, rather than the entire document, Microsoft Excel provides a handy feature. This article guides you through the process of printing a selected area of your worksheet.

Before we delve into the steps, ensure you have selected the specific area you want to print. You can do this by clicking and dragging your cursor over the required cells. Only the selected area will be affected, so be precise with your selection.

Setting Up Your Print Area

The first step is to define the print area in your worksheet. This area will be the only one Excel considers when giving print commands.

Set Print Area in Excel
Set Print Area in Excel
the surface area of cones and spheres worksheet is shown in this image
the surface area of cones and spheres worksheet is shown in this image
Finding the Area in Total Units Worksheet
Finding the Area in Total Units Worksheet

To set the print area, follow these steps:

Defining the Print Area

1. Select the area you want to print. This can be a range of cells, a table, or even a chart.

Area and Perimeter: Practice Worksheets
Area and Perimeter: Practice Worksheets
Free Printable PDF Math Worksheet
Free Printable PDF Math Worksheet
Teaching Differentiated Area in Math: Ideas to Make Practicing Area Fun -
Teaching Differentiated Area in Math: Ideas to Make Practicing Area Fun -

2. Click the 'Page Layout' tab in the ribbon, then click 'Print Area' in the 'Page Setup' group. A dropdown menu will appear.

3. Select 'Set Print Area' from the dropdown menu. Now, only the selected area will print.

Printing the Selected Area

Once you've defined the print area, you can proceed to print the selected content.

the worksheet for what are they doing?, which includes pictures and instructions
the worksheet for what are they doing?, which includes pictures and instructions
worksheet showing the area and perimeters for students to practice their math skills
worksheet showing the area and perimeters for students to practice their math skills
printable worksheet for comparing area and perimeters
printable worksheet for comparing area and perimeters
Irregular Shapes: Finding Area and Perimeter of Irregular Shapes worksheet
Irregular Shapes: Finding Area and Perimeter of Irregular Shapes worksheet
Printables Maths Worksheets | K5 Worksheets
Printables Maths Worksheets | K5 Worksheets
Print Only Selected Areas of a Spreadsheet in Excel 2007 & 2010
Print Only Selected Areas of a Spreadsheet in Excel 2007 & 2010

1. Press Ctrl + P (or Command + P on a Mac) to open the Print dialog box.

2. Ensure the correct printer is selected in the 'Printer' section, then click 'Print'. Only the previously defined print area will be printed.

Manipulating the Print Area

Excel allows you to adjust the print area to better suit your needs.

Calculating Surface Area #1 | Interactive Worksheet | Education.com
Calculating Surface Area #1 | Interactive Worksheet | Education.com
Finding the Area by Multiplying Worksheet
Finding the Area by Multiplying Worksheet
Printable Perimeter Worksheet for 4th Grade Math Measurement Practice
Printable Perimeter Worksheet for 4th Grade Math Measurement Practice

Here are two common adjustments you might need to make:

Changing the Print Area

You can change the print area at any time. To do this, simply follow the steps under 'Defining the Print Area' and select a new area.

To delete the print area entirely and print the entire worksheet again, click 'Clear Print Area' in the 'Page Setup' group of the 'Page Layout' tab.

Printing Multiple Areas

If you need to print more than one area, you can do so by defining each area as a print area, as described above. Then, print the document as you usually would.

Excel will print each defined print area on separate pages.

That's it! You've now mastered the art of printing selected areas from your worksheet. This feature can save you a significant amount of paper and ink, making it a valuable tool for anyone working with large or complex worksheets.