You are currently offline, waiting for your internet to reconnect

You cannot use the AutoFit feature for rows or columns that contain merged cells in Excel

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

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.
SYMPTOMS
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.
CAUSE
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.
WORKAROUND
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

  • On the Format menu, point to Row, and then click Height.
  • On the Format menu, point to Column, and then click Width.

Microsoft Office Excel 2007

  • On the Home tab, click Format in the Cells group, and then click Row Height.
  • On the Home tab, click Format in the Cells group, and then click Column Width.
Auto Fit Bestfit Best Wrap Text XL2000 xl2003 XL2007
Properties

Article ID: 212010 - Last Review: 02/08/2007 19:05:53 - Revision: 5.2

Microsoft Office Excel 2007, Microsoft Office Excel 2003, Microsoft Excel 2002 Standard Edition, Microsoft Excel 2000 Standard Edition, Microsoft Excel 97 Standard Edition

  • kbadp kbprb KB212010
Feedback
/html>//c1.microsoft.com/c.gif?DI=4050&did=1&t=">