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.

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.

Select the worksheet or worksheets you want to print, and then click the "Page Layout" tab. Check "Print" under Gridlines in the Sheet Options group, and then press "Ctrl-P" to go to the Print window.

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 ...

Please note: This item is from our archives and was published in 2001. It is provided for historical reference. The content may be out of date and links may no longer function. Q. I regularly print ...