Microsoft KB Archive/157097

{|
 * width="100%"|

XL97: Cannot AutoFit Rows/Columns That Contain Merged Cells

 * }

-

The information in this article applies to:


 * Microsoft Excel 97 for Windows

-

SYMPTOMS
In Microsoft Excel 97, you may be unable to AutoFit columns or rows that contain merged cells.

CAUSE
In Microsoft Excel 97, you cannot AutoFit a column that contains a cell merged with cells in other columns. Likewise, you cannot AutoFit a row that contains a cell merged with cells in other rows.

STATUS
This is by design in Microsoft Excel 97.