XL2000: Text Is Cut Off in Cell When You Select the Bottom Alignment Setting

The bottom rows of text in a cell may be cut off and therefore not visible, even though the cell is formatted with a vertical alignment setting of Bottom.

This behavior can occur if the cell is not large enough to display all of the text that it contains.

To work around this issue, use any of the following methods to size the cell so that it can display all of the text that it contains:

• Increase the column width of the cell.
  
  To do this, select the cell, and on the Format menu, point to Column, and then click Width. Increase the column width and click OK.
• Increase the row height of the cell.
  
  To do this, select the cell, and on the Format menu, point to Row, and then click Height. Increase the row height and click OK.
• Reduce the amount of text contained in the cell so that it is displayed without resizing the cell.

Note that if you set the vertical alignment of the cell to Top, the top rows of text in the cell are visible even if the cell is not large enough to display all of the text that it contains.

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

In Microsoft Excel, there are a number of vertical alignment settings that you can apply to cells: for example, Top, Bottom, and Center.

If you format a cell to use a vertical alignment of Top, the text is aligned with the top of the cell. If the cell contains too much text, the bottom rows of text are truncated by the bottom of the cell. This behavior is by design of Microsoft Excel and is the intended behavior.

However, if you format the same cell to use a vertical alignment of Bottom, the text is not correctly aligned with the bottom of the cell if the cell contains too much text. If you increase the size of the cell or reduce the amount of text in the cell, the text is correctly aligned with the bottom of the cell.