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.

2. Print Multiple Sheets or the Entire Workbook. If your Excel file contains several sheets and you want to print more than one, or even the entire workbook, Excel makes it simple to do so.

How do I print a background grid in Excel? To print a background grid in Excel, you need to open the spreadsheet and go to the Page Layout tab. Then, head to the Sheet Options panel.

For instance, if you would like to print column labels at the top of every printed page, you could enter $1:$1 in the Rows to repeat at top box.. Once you are done with the job of setting up your ...

Printing a colorized Excel spreadsheet in black and white is easy, whether you do so manually or using a short VBA procedure. Here's how.