In Excel, you can select a range of cells and designate those cells as an area of the worksheet you routinely want to print. This is known as a Print Area.
Unfortunately Excel allows you to designate only one range of cells as a print area. This limitation is irritating when you have a large worksheet that includes several areas you want to print. For example, if you have a worksheet that includes a list of countries divided up by region, you might want to print each region separately instead of printing the entire sheet. This limitation can be overcome by using range names instead of the Print Area feature.
Start off by selecting the cells for your first range you want to print. If you have a large worksheet, you will have greater control in highlighting cells if you use your keyboard to select cells. How? Select the first cell in the range. Press the Shift key and use the arrow keys on your keyboard to expand the selection.
2. Once you have the range selected, create a name for that range. How?
Name a cell or a range of cells
 |  Select
the cell, range of cells, or nonadjacent
selections (cells not touching) that you want to name. |
| Click the Name box at the left end of the formula bar |
Name box
o Type the name for the cells.
o
Press
ENTER.
3. Repeat this process for each range you want to be able print separately.
If you have rows or columns of headings or labels you want to print along with the data, you can designate these rows or columns in the Page Setup dialog box. The feature that allows you to do this is called “Print Titles”. Choose File, Page Setup and click the Sheet tab. If you have, for example, a row you want to repeat at the top of each printed page, click in the Row To Repeat At Top field in the Print Titles area of the dialog box. Then click anywhere in that row in your worksheet (displayed behind the dialog box). Suppose the row you want to repeat is row 4, the field in the Page Setup dialog box will display $4:$4.
Once you have the range names created and the page setup options selected, you are ready to print. Here are the steps you want to follow:
print. The easiest way to do this is to select the range name from the Name box on the Formula Bar. This is the box that typically displays the cell address. There is a drop-down arrow on the right side of the box. When you click that arrow, a list of all the range names you created displays. If you are having trouble locating the Name box, an alternative way to see a list of the range
names is to press F3. A pop-up box displays the range names. Select the name and choose OK.
cannot use the Print button on the toolbar or the keyboard shortcut (Ctrl+P) to print a range --- you MUST use the Print dialog box.
You can repeat these three steps for each range you want to print.
Frequently, you may want to print several groups of cells, skipping a few rows or columns. For example, you might want to select cells A4:D10 and F4:H10 to print, skipping column E entirely.
How do you select multiple ranges? Highlight the first range. Then press the Ctrl key as you highlight each additional range.
When you select several ranges, normally Excel prints each range on a separate page. To preview how this looks, do not use the Print Preview button on the toolbar. Instead choose
File, Print and in the Print dialog box mark Selection and click the Preview button.
However, you can have these ranges appear on one printed page by “fooling” Excel. First, you must hide (temporarily) the rows or columns you don’t want to print. In our example, this would mean hiding column E. To hide a column, select any cell in that column and choose Format, Column, and Hide. To hide a row, you would choose Format, Row, and Hide.
After the column is hidden, you can select the ranges you want to print. Now, you must choose File, Print. You can not use the Print button on the Standard toolbar or the keyboard shortcut (Ctrl+P) to print. The reason? Because the default printing option will print the entire worksheet. If you want to print only part of the worksheet, you must tell Excel that. Choose File, Print and mark the Selection option. The cells will be printed on one page.
You’ll want to redisplay the column(s) you’ve hidden. The trick to unhiding a column is to select the column headings on either side of the hidden column. If column E has been hidden, you would select column D and drag the selection to column F. After the columns on either side of the hidden column are selected, choose Format, Column, Unhide. You can apply these same principles for unhiding rows.