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:

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.