XL: Objects Overlap Onto Next Page With PCL Printers

 Last reviewed: March 16, 1998
Article 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 do the following:

  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
Keywords : xlprint kbprint
Version : WINDOWS:7.0,97
Platform : WINDOWS
Issue type : kbprb

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 16, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.