Objects Overlap Onto Next Page With PCL Printers (157503)


The information in this article applies to:

  • Microsoft Excel 97 for Windows
  • Microsoft Excel for Windows 95
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:
  4. On the Tools menu, click Options.
  5. Click the View tab.
  6. Click in the Gridlines Color box and select White.
  7. Click OK.
Modification Type:MinorLast Reviewed:8/17/2005
Keywords:kbprb kbprint KB157503
©2004 Microsoft Corporation. All rights reserved.