The information in this article applies to:
SYMPTOMS
In Microsoft Excel version 5.0, if you format a cell with the Center
Across Selection, and Wrap Text formatting, and you hide the column that
contains this cell, the AutoFit command works incorrectly for the row that
contains this hidden cell. If you hide the row that contains this cell, the
AutoFit command works incorrectly for the column that contains this hidden
cell.
CAUSE
This behavior occurs only when the hidden cell contains both the
Center Across Selection and the Wrap Text formatting. When you use
the AutoFit command with the row or column that contains this hidden
cell, the row height or column width increases incorrectly. The resulting
height or width depends on the length of the data that is contained in the
hidden cell; that is, the greater the length of the data contained in the
hidden cell, the greater the height or width increases using AutoFit.
WORKAROUNDTo avoid this behavior, you must use the Row Height or Column Width dialog boxes to change the height of the row or the width of the column that contains the hidden cell. STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in a later version of Microsoft Excel. REFERENCES
For more information about Adjusting Column Width or Adjusting Row
Height, choose the Search button in Help and type:
Additional query words:
Keywords : |
Last Reviewed: July 29, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |