Microsoft KB Archive/181911

= XL98: Printing Nonadjacent Areas on One Sheet =

Article ID: 181911

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q181911



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:

  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  Select Row 3. On the Format menu, point to Row, and then click Hide. Select A1:B5. On the File menu, point to Print Area, and then click Set Print Area. The selected items will now print as one page.



STATUS
This is by design of Microsoft Excel.

<div class="moreinformation_section">

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:

  Type the following in a new workbook: <pre class="fixed_text">    A1:Test1   B1:Test1 A2:Test1  B2:Test1 A3:       B3: A4:Test2  B4:Test2 A5:Test2  B5:Test2 </li> Select A1:B2. Hold down the COMMAND key and select A4:B5.</li> On the File menu, point to Print Area, and click Set Print Area.</li> On the File menu, click Print Preview.</li></ol>

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

<div class="references_section">