Article ID: 212010 - View products that this article applies to.
This article was previously published under Q212010
For a Microsoft Excel 98 version and a Microsoft Excel 2001 for Mac version of this article, see 179045
You may be unable to use the AutoFit feature for columns or rows that contain merged cells in Microsoft Excel. In addition, if the Wrap Text feature is also selected, text is not wrapped automatically.
In Excel, you cannot use the AutoFit feature on a column that contains a cell merged with cells in other columns. Likewise, you cannot use AutoFit on a row that contains a cell merged with cells in other rows.
When you use merged cells, manually adjust row height and column width by using the following procedures, as appropriate for the version of Excel that you are running.
Microsoft Office Excel 2003 and earlier versions of Excel
Microsoft Office Excel 2007
Article ID: 212010 - Last Review: February 8, 2007 - Revision: 5.2
Contact us for more help
Connect with Answer Desk for expert help.