Microsoft KB Archive/47579

From BetaArchive Wiki

Excel: Creating and Printing Multiple Print Areas

Last reviewed: November 2, 1994
Article ID: Q47579


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.


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, "Print1" or "Print2").
  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, "Print1").
  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.

KBCategory: kbother


Additional reference words: 1.00 1.03 1.04 1.06 1.50 2.20 3.00

Last reviewed: November 2, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.