Knowledge Base

Objects Overlap Onto Next Page With PCL Printers

Article ID: 157503

Article Last Modified on 8/17/2005

APPLIES TO

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.

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

Keywords: kbprint kbprb KB157503


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.