XL98: Printing Nonadjacent Areas On One Sheet

Last reviewed: March 2, 1998
Article ID: Q181911
The information in this article applies to:
  • Microsoft Excel 98 Macintosh Edition

SYMPTOMS

In Microsoft Excel 98 Macintosh Edition, you attempt to print out separate sections of a workbook on one page, but instead they print on multiple pages.

CAUSE

This behavior occurs when you set multiple nonadjacent Print Areas in a workbook.

WORKAROUND

To work around this behavior, hide the columns and rows between the areas and set a single, continuous print area to print everything on one page. An example of how to do this is as follows:

  1. In a new workbook, type the following:

          A1:Test1   B1:Test1
          A2:Test1   B2:Test1
          A3:        B3:
          A4:Test2   B4:Test2
          A5:Test2   B5:Test2
    
    

  2. Select Row 3. On the Format menu, point to Row, and then click Hide.

  3. Select A1:B5. On the File menu, point to Print Area, and then click Set Print Area.

  4. The selected items will now print as one page.

STATUS

This is by design of Microsoft Excel.

MORE INFORMATION

When you set multiple nonadjacent Print Areas in a workbook, Microsoft Excel treats each Print Area as a separate page. To see an example of this behavior, follow these steps:

  1. Type the following in a new workbook:

         A1:Test1   B1:Test1
         A2:Test1   B2:Test1
         A3:        B3:
         A4:Test2   B4:Test2
         A5:Test2   B5:Test2
    
    

  2. Select A1:B2. Hold down the COMMAND key and select A4:B5.

  3. On the File menu, point to Print Area, and click Set Print Area.

  4. On the File menu, click Print Preview.

Notice in the Print Preview window, that Microsoft Excel would print two pages if you were to click the Print button.

REFERENCES

For more information about Print Areas, click Contents And Index on the Help menu (or on the Balloon Help menu if you are using a version of the Macintosh operating system earlier than 8.0), click the Index button in Microsoft Excel Help, type the following text

   print area

and then click Show Topics. Select the "Print a specific area of a workbook" topic, and click Go To. If you are unable to find the information you need, ask the Office Assistant.


Additional query words: XL98
Keywords : xlprint kbdta
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbprb


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: March 2, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.