Excel: Creating and Printing Multiple Print Areas

 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, "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
KBSubcategory:

Additional reference words: 1.00 1.03 1.04 1.06 1.50 2.20 3.00

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

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