Microsoft KB Archive/47579

{| = Excel: Creating and Printing Multiple Print Areas =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q47579

SUMMARY
The following article details how to specify multiple distinct print areas in order to print only selected information at a given time from Microsoft Excel. For example, if the area A1:G50 is a distinct area that you print frequently and the area H1:M75 is a separate area that you also print frequently (but you do not want to print both of these areas at the same time), you could use the following procedure so that you don't have to manually select these areas each time they are to be printed.

MORE INFORMATION
To set multiple print areas in Microsoft Excel, do the following:


 * 1) Select the area you want to print.
 * 2) From the Formula menu, choose Define Name.
 * 3) Give your print area a name (for example, &quot;Print1&quot; or &quot;Print2&quot;).
 * 4) Repeat the above steps, giving each area a different name, until you have defined all the areas that you desire as print areas.

When you want to print each area, do the following:
 * 1) From the Formula menu, choose Goto.
 * 2) Select one of the defined names (for example, &quot;Print1&quot;).
 * 3) Click OK. Excel selects the specified area.
 * 4) From the Options menu, choose Set Print Area.
 * 5) From the File menu, choose Print.

Although you can have only one actual print area defined at a time, this method allows you to quickly select frequently printed areas. Once you have defined a print area using Set Print Area, Excel prints only that area of the worksheet until you set a new print area or remove the print area.

To remove a print area, do the following:


 * 1) From the Formula menu, choose Define Name.
 * 2) Select the name Print_Area.
 * 3) Click Delete.
 * 4) Click OK.
 * }