Text in Compressed Row May Extend into Row Above in Printout

 Last reviewed: November 4, 1994
Article ID: Q72443
The information in this article applies to:
  • Microsoft Excel for Windows, versions 3.0, 4.0, 5.0

SUMMARY

In the Microsoft Excel versions listed above, data that is contained in a compressed row (a row with a very small row height) may extend into the row above when the worksheet is printed. This does not occur if the cells in the compressed row are formatted with a Windows vector font (Modern, Roman, or Script).

MORE INFORMATION

On some printers you may see text or numbers contained in compressed rows printing over the cells in the row above. This is the result of the inability of some printer drivers to clip nonvector (raster) fonts.

Workaround

The only solution is to use vector fonts. Otherwise, the offending data must be removed from the compressed row.

Steps to Reproduce Problem

  1. Type "Top Cell" (without quotation marks) in cell A1 of a worksheet and type "Hidden Cell" in cell B1.

  2. Format the cells with something other than a vector font.

  3. Select cell B1 then choose Row Height from the Format menu.

  4. In the Row Height field, enter "2" (without quotation marks).

  5. Print the worksheet to a LaserJet printer (other printers drivers exhibit similar behavior).

In your printout you may see the text in cell B1 extending into cell A1. This problem may or may not occur if the row height is smaller than 2.

KBCategory: kbprint
KBSubcategory:

Additional reference words: 3.0 3.00 4.0 4.00 5.0 5.00

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: November 4, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.