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


The information in this article applies to:

  • Microsoft Office Excel 2003
  • Microsoft Excel 2002
  • Microsoft Excel 2000
  • Microsoft Excel 97 for Windows
This article was previously published under Q212010
For a Microsoft Excel 98 and 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 addition, if the Wrap Text feature is also selected, text is not wrapped automatically.

CAUSE

In Microsoft 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 commands:
  • On the Format menu, point to Row, and then click Height.

    -or-
  • On the Format menu, point to Column, and then click Width.

REFERENCES

For more information about adjusting row heights and column widths, click Microsoft Excel Help on the Help menu, type change column width in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
Modification Type:MinorLast Reviewed:8/27/2004
Keywords:kbADP kbprb KB212010
©2004 Microsoft Corporation. All rights reserved.