XL97: Cannot AutoFit Rows/Columns That Contain Merged Cells

Last reviewed: January 15, 1998
Article 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
Keywords : xlformat
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbprb

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: January 15, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.