Microsoft KB Archive/149663

= Wrap text does not adjust row height in Excel =

Article ID: 149663

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel X for Mac
 * Microsoft Excel 2001 for Mac
 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q149663



SYMPTOMS
In Microsoft Excel, if you manually modify the height of a row and then format a cell in that row to wrap text, Excel does not change the height of the row to fit all the text in the cell.



CAUSE
This behavior occurs if you have manually modified the height of the row.



WORKAROUND
To adjust the height of the row to fit all the text in a cell, follow these steps:
 * 1) Select the row.
 * 2) In Microsoft Office Excel 2003 and in earlier versions of Excel, point to Row on the Format menu, and then click AutoFit.

In Microsoft Office Excel 2007, click the Home tab, click Format in the Cells group, and then click AutoFit Row Height.



STATUS
This behavior is by design.

Additional query words: 8.00 XL97 98 XL98 XL2003 XL2007 XL2000 XL2002

Keywords: KB149663

-

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

© Microsoft Corporation. All rights reserved.