XL2000: Cannot Reset a Column to the Standard Width

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

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.

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, Excel does not change the column to match the new Standard column width setting.

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

For more information about changing column width, click Microsoft Excel Help on the Help menu, type Change column width in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

For more information about changing row height, click Microsoft Excel Help on the Help menu, type Change row height in the Office Assistant or the Answer Wizard, and then click Search to view the topic.