XL97: Cannot AutoFit Rows/Columns That Contain Merged Cells

The information in this article applies to:

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
Technology :


Last Reviewed: November 4, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.