Microsoft KB Archive/64647

{| = Excel: Text Does Not Flow into Adjacent Cells =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q64647

SUMMARY
In Microsoft Excel, if a long text string is entered into a cell, the text is cut off instead of flowing into the adjacent cell if any of the following conditions is true:


 * 1) The cell to the right of the text string is not empty. To correct this, select the cell to the right and press the DELETE or BACKSPACE key.
 * 2) The worksheet or macro sheet is displaying formulas rather than values. To correct this, choose Display from the Options menu and check to see that the Formulas option is deselected.
 * 3) The cell that contains the text string is formatted as Fill. To check this, select the cell, and then choose Alignment from the Format menu. In the Alignment dialog box, check to see if Fill is selected. If so, select General or any other appropriate option.
 * }