XL98: Cannot Reset a Column to the Standard Width (181903)


The information in this article applies to:

  • Microsoft Excel 98 Macintosh Edition
This article was previously published under Q181903

SYMPTOMS

When you point to Column on the Format menu and click Standard Width, the column width is not reset to the Standard Column Width setting.

CAUSE

This problem occurs if you change the width of a column from the original width. Microsoft Excel cannot automatically reset the width of the column.

WORKAROUND

To manually resize the column to the width used by the Standard Width command, follow these steps:
  1. Click any cell in the column that you want to resize.
  2. On the Format menu, point to Column, and then click Standard Width. Note the width in the Standard Column Width box and click OK.
  3. On the Format menu, point to Column and click Width. In the Column Width dialog box, type a width that is equal to the Standard Column Width setting and click OK.
The column width matches the Standard Column Width setting.

NOTE: If you change the Standard Column Width setting, Microsoft Excel does not change the column to match the new Standard Column Width setting.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

REFERENCES

For more information about setting Column widths and Row heights, click Contents And Index on the Help menu (or on the Balloon Help menu if you are using a version of the Macintosh operating system earlier than 8.0), click the Index button in Microsoft Excel Help, type the following text 
   columns, width
and then click Show Topics. Select the "Change column width and row height" topic, and click Go To. If you are unable to find the information you need, ask the Office Assistant.
Modification Type:MajorLast Reviewed:9/11/2002
Keywords:kbbug KB181903
©2002 Microsoft Corporation. All rights reserved.