XL98: Printing Nonadjacent Areas on One Sheet (181911)

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.

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.

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:

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

Select A1:B2. Hold down the COMMAND key and select A4:B5.
On the File menu, point to Print Area, and click Set Print Area.
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.