How to Print a Selection in Excel 2010


Excel worksheets and workbooks can easily become very large, and a lot of the information that they contain might only be useful in specific situations. So when you are printing data that is meant to summarize the contents of a spreadsheet, it is helpful to omit extraneous data in an effort to simplify the print job and make it easier to read. We have previously written about how to set a print area in Excel 2010, which is helpful if you always need to print a specific set of data from a spreadsheet. But if you need to print different elements at different times, then a print area is not the best option. So continue reading below to learn how to only print your selection in Excel 2010.

 

Print Selected Cells in Excel 2010

This tutorial is going to teach you how to print a specific set of cells in Excel 2010 that are defined by what you have currently selected. A selection in Excel is defined by the cells that are highlighted when you click your mouse on a cell and drag the mouse to select additional cells. With that knowledge in hand, you can elect to print only your selected cells.

 

Step 1: Open your spreadsheet in Excel 2010.

 

Step 2: Click your mouse on the first cell that you want to include in your selection, then drag the mouse to select the rest of the cells.

select the cells that you want to print

 

 

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

click the file tab at the top of the window

 

 

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

click the print tab at the left of the window

 

 

Step 4: Click the Print Active Sheets button at the center of the window, then select the Print Selection option.

how to print a selection in excel 2010

 

 

Step 5: Click the Print button at the top of the window.

 

 

If you print a lot of large documents on an inkjet printer, then you might be frustrated by the cost of ink and the slow speed of the printer. Purchasing a black and white laser printer, such as this Brother HL-2270DW, will result in a lower cost-per-sheet, plus it will print faster.

If you decide that using print areas is a better option for you, then make sure you also know how to clear a print area in Excel 2010 as well.

birthday t-shirts for boys
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.