The information in this article applies to:
SYMPTOMS
In Microsoft Excel, when you use the Zoom feature to reduce or enlarge the
displayed worksheet after you use the AutoFit feature (Best Fit in versions
4.0 and 4.0a) to set the column width, some cells may be filled with #
characters. CAUSE
This problem occurs because the AutoFit and Best Fit options apply only to
the current Zoom factor. Microsoft Excel uses the screen font at the
current zoom factor to calculate the best fit for a cell.
WORKAROUND
To redisplay the worksheet such that it does not contain the # characters,
use the appropriate method for your situation.
a. Select the affected cells.Method 2: If you are using Microsoft Excel version 4.0 or 4.0a: a. Select the affected cells. REFERENCES
"User's Guide," version 5.0, pages 201-203 Additional query words: pound sign signs display
Keywords : |
Last Reviewed: March 24, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |