Best Fit Does Not Dynamically Change Column Width

 Last reviewed: November 1, 1994
Article ID: Q68014
The information in this article applies to:
  • Microsoft Excel for Windows, versions 3.0, 4.0, 4.0a, 5.0

SUMMARY

If you chose the AutoFit command (from the Format menu, choose Column, and then choose AutoFit) or the Best Fit command (Microsoft Excel 4.0 and earlier) to change the size of a column, and you then enter more information in a cell in that column so that the entry is longer than the new optimal column width, the column width is not changed to accommodate the new text.

To change the column width to fit the new text, choose AutoFit or Best Fit again or click the border of the column header.

MORE INFORMATION

When you choose AutoFit or Best Fit, Microsoft Excel determines the minimum width necessary to display the contents of the selected cells. When you click the column header border, Microsoft Excel determines the minimum width necessary to display the contents of the entire column.

REFERENCES

"User's Guide," version 5.0, pages 202, 203 "User's Guide 1," version 4.0, pages 114, 233 "User's Guide," version 3.0, pages 200-201

KBCategory: kbusage
KBSubcategory:

Additional reference words: 3.00 4.00 4.00a 5.00

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: November 1, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.