How to Do Selective Printing in Excel. When you need to print only a limited range of worksheet data, Microsoft Excel 2010 offers a "Set Print Area" option to help you manage your print content.

To define the print area for your worksheet, highlight the columns and rows to include, select "Print Area" on the Page Layout tab, and then choose "Set Print Area" from the drop-down menu.

HOW TO: On the worksheet, select the cells that you want to define as the print area. On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.

Q. I regularly print many different sections of a large and complex spreadsheet. Since I don’t want to print the entire workbook, I must highlight the area to be printed and then, when I evoke the ...

I have an Excel spreadsheet that I use to track my investments, and I’d like to print it to take to my tax guy. I don’t want to print the whole thing, though — I need to find some way to just print a ...