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 set print area in Excel. For the sake of this example, we use a small set of data about employees of a fictitious company. The dataset includes position, division, city, and date of hire.

Show Comments is activated in Excel, with the Comments pane displaying two comment threads. At End Of Sheet is selected in the Print section of the Sheet tab in the Page Setup dialog box in Excel.

The print settings in Microsoft Excel 2010 control settings like the spreadsheet's margins, its orientation, the size of the printed sheet and whether or not the printing will be collated. If.