XL97: Cannot AutoFit Rows/Columns That Contain Merged Cells

ID: Q157097

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.

REFERENCES

For more information about adjusting row widths and column heights, click the Index tab in Microsoft Excel Help, type the following text

   columns, width

click the Display button and then double-click the topic for "Change column width and row height".

Additional query words: XL97 Auto Fit Bestfit Best Wrap Text

Keywords          : xlformat 
Version           : WINDOWS:97
Platform          : WINDOWS
Issue type        : kbprb

Last Reviewed: November 1, 1998