Microsoft KB Archive/214357

= XL2000: Text Is Wrapped Incorrectly When Typed in a Cell =

Article ID: 214357

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q214357





SYMPTOMS
In Microsoft Excel, when you type text in a cell, and then press ENTER, a character may move from one line to the next line in the cell.

For example, the behavior is illustrated in the following table:   Appearance of          Appearance of text after typed text            you press ENTER -

ReviewCycleIII        ReviewCycleII I

Alphabravoch          Alphabravoc arlie                 harlie This problem may cause text that appears on a single line when you type it, to appear on two lines.



CAUSE
This problem may occur when the following conditions are true:
 * You select the cell, click Cells on the Format menu, click the Alignment tab, click to select the Wrap text check box, and then click OK.

-and-
 * The text that you are typing in the cell is almost exactly the same width as the cell.

-and-
 * The text contains a single word that is too long to be displayed on a single line.

Specifically, the problem occurs because the space that is enclosed by the cell outline (the border that indicates which cell is currently selected) increases slightly in width when you edit the cell. If the text is almost exactly the same width as this space, Microsoft Excel wraps the text when you press ENTER. This behavior occurs because the space that is enclosed by the cell outline decreases slightly in width.



WORKAROUND
To work around this problem, do either of the following:
 * Either increase or decrease the width of the column that contains the cell in which the problem occurs.

-or-
 * Increase or decrease the size of the font that you use in the cell so that the text does not exactly fill the space inside the cell outline.



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



MORE INFORMATION
In Microsoft Excel, you can wrap text in a single cell by applying "Wrap text" formatting to the cell. To do this, follow these steps:
 * 1) Select the cell to which you want to apply the format.
 * 2) On the Format menu, click Cells.
 * 3) On the Alignment tab, click to select the Wrap text check box, and then click OK.

When you type text in the cell, the text is automatically wrapped to multiple lines if necessary.

Keywords: kbbug kbpending KB214357

-

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

© Microsoft Corporation. All rights reserved.