XL98: Printing Nonadjacent Areas on One Sheet

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 : kbprint kbdta
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbprb


Last Reviewed: January 13, 2000
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.