Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Text Is Cut Off When Cell Uses Bottom Alignment


View products that this article applies to.

Symptoms

The bottom rows of text in a cell may not be visible (they are cut off), even though the cell is formatted with a vertical alignment of Bottom.

↑ Back to the top


Cause

This problem occurs if the cell is not large enough to display all of the text it contains.

↑ Back to the top


Workaround

To prevent this problem from occurring, use any of the following methods to size the cell so that it can display all of the text it contains:
  • Increase the column width of the cell. To do this, select the cell, click the Format menu, point to Column, and click Width. Increase the column width and click OK.
  • Increase the row height of the cell. To do this, select the cell, click the Format menu, point to Row, and click Height. Increase the row height and click OK.
  • Use the AutoFit feature to allow Microsoft Excel to automatically determine the correct column width or row height to use. To use AutoFit, select the cell, click the Format menu, point to Column or Row, and click AutoFit.
  • 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 it contains.

↑ Back to the top


Status

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

↑ Back to the top


More information

In Microsoft Excel, there are a number of vertical alignments 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 is by design of Microsoft Excel and is correct 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 if you reduce the amount of text in the cell, the text is correctly aligned with the bottom of the cell.

↑ Back to the top


Keywords: KB169101, kbprb

↑ Back to the top

Article Info
Article ID : 169101
Revision : 4
Created on : 8/17/2005
Published on : 8/17/2005
Exists online : False
Views : 408