Printing Multiple Worksheet Ranges

If you have multiple named ranges that you want to print (and the ranges are on the same worksheet), you may be wondering how you can easily do this in Excel. The easiest way is by following these steps if you are using Excel 2007:

1. Make sure the worksheet whose named ranges you want to print is selected.
2. Display the Page Layout tab of the ribbon.
3. In the Page Setup group click the Print Area tool and then click Clear Print Area. This clears the print area, just in case one was previously defined.
4. Using the Name Box drop-down list (right above cell A1), select the first named range you want printed.
5. Hold down the Ctrl key and use the Name Box drop-down list to select each of the other named ranges you want to print.
6. In the Page Setup group click the Print Area tool and then click Set Print Area. Excel marks each of your ranges as part of the print area.
7. Print as you normally would.

If you are using an older version of Excel, follow these steps instead:

1. Make sure the worksheet whose named ranges you want to print is selected.
2. Choose Print Area from the File menu. Excel displays a submenu.
3. Choose Clear Print Area from the submenu. This clears the print area, just in case one was previously defined.
4. Using the Name Box drop-down list (right above cell A1), select the first named range you want printed.
5. Hold down the Ctrl key and use the Name Box drop-down list to select each of the other named ranges you want to print.
6. Choose Print Area from the File menu. Excel displays a submenu.
7. Choose Set Print Area from the submenu. Excel marks each of your ranges as part of the print area.
8. Print as you normally would.