XL: Objects Overlap Onto Next Page With PCL Printers

ID: Q157503

The information in this article applies to:

• Microsoft Excel for Windows, version 7.0
• Microsoft Excel 97 for Windows

SYMPTOMS

When you print a worksheet that contains a drawing object that overlaps a horizontal page break, although the entire object prints on that page, part of the object may print on the next page.

CAUSE

This behavior occurs when you print to any printer whose driver uses the Printer Control Language (PCL).

WORKAROUND

To print the worksheet correctly, turn the gridlines on for printing. This will force the object to print in the cells in which it is anchored.

To turn on gridlines, follow these steps:

1. On the File menu, click Page Setup.

2. Click the Sheet tab and select the Gridlines check box.

3. Click OK.

   To not display the gridlines when you print, add the following steps to
   those above:

5. Click the View tab.

6. Click in the Gridlines Color box and select White.

7. Click OK.

Additional query words: XL97 XL7 8.00 7.00 clip truncate ghost image

Keywords          : kbprint xlprint 
Version           : WINDOWS:7.0,97
Platform          : WINDOWS
Issue type        : kbprb

Last Reviewed: January 7, 1999