Microsoft KB Archive/213899

= XL2000: Wrap Text Format Causes Text to Move Closer to Top of Cell =

Article ID: 213899

Article Last Modified on 9/27/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q213899





SYMPTOMS
In Microsoft Excel 2000, if you apply the Wrap text alignment format to a cell, the text in the cell may move slightly closer to the top of the cell. As a result, text in one cell may not be vertically aligned with text in another cell in the same row.

This problem is more noticeable when the text in the cell is bold, or when you apply borders to the cell.

NOTE: This problem does not occur in versions of Excel earlier than Excel 97.



WORKAROUND
You can reduce the effects of this problem by formatting all cells in a row with the Wrap text alignment format. To do this, follow these steps:
 * 1) Select all of the cells in the row that you are using.
 * 2) On the Format menu, click Cells. Click the Alignment tab.
 * 3) Click to select the Wrap text check box, and then click OK.

If all of the cells in the row use the Wrap text alignment format, the text in all of the cells is aligned.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



MORE INFORMATION
When you use the Wrap text alignment format, text that is too long to appear on one line is wrapped so that it appears in multiple lines in a single cell.

Additional query words: XL2000

Keywords: kbbug kbpending KB213899

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.