Excel: Creating and Printing Multiple Print AreasLast reviewed: November 2, 1994 |
SUMMARYThe 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 INFORMATIONTo set multiple print areas in Microsoft Excel, do the following:
When you want to print each area, do the following:
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:
|
KBCategory: kbother Last reviewed: November 2, 1994 |