Microsoft KB Archive/157503

= Objects Overlap Onto Next Page With PCL Printers =

Article ID: 157503

Article Last Modified on 8/17/2005

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 95 Standard Edition

-



This article was previously published under Q157503





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:
 * 1) On the Tools menu, click Options.
 * 2) Click the View tab.
 * 3) Click in the Gridlines Color box and select White.
 * 4) Click OK.

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

Keywords: kbprint kbprb KB157503

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.