Text in Compressed Row May Extend into Row Above in Printout

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 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 .


  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.

Additional query words: 3.0 4.0 5.0

Keywords :
Version :
Platform :
Issue type :


Last Reviewed: July 29, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.