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.

Wrap Text Format Causes Text to Move Closer to Top of Cell

View products that this article applies to.

This article was previously published under Q176247

↑ Back to the top


In Microsoft Excel, 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 earlier versions of Microsoft Excel.

↑ Back to the top


You can reduce the effects of this problem by formatting all cells in a row with the Wrap Text alignment. 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. 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.

↑ Back to the top


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

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.

↑ Back to the top

Keywords: KB176247, kbbug

↑ Back to the top

Article Info
Article ID : 176247
Revision : 2
Created on : 8/15/2003
Published on : 8/15/2003
Exists online : False
Views : 40