How to reset column to standard width?

[Rich Pasco]

How can I remove the width setting from a column, so that its width
will track future changes in the "standard width" for that spreadsheet?

I'm using Excel 2000 9.0.6926 SP-3 under Windows 2000.

- Rich

 

[Don Guillett]

As Bubba said, It depends on what your definition of "standard width" is
activecolumn.columnwidth=8.43

 

[Rich Pasco]

As Bubba said, It depends on what your definition of "standard width" is

No, I am not talking about *setting* the width of a column equal to that
which happens to be the current "standard width." I am talking about
removing the setting entirely, so that the column will take on whatever
values the "standard width" is set to in the future.

If this difference is not clear to you, please don't cloud the issue.

- Rich

 

[Rich Pasco]

Apparently what I want wasn't clear to some, so let me try again.
If I invoke Format / Column / Standard Width, and enter a new value,
then most (but not all) of my columns change width to the new value.
Some (those columns for whom I had previously explicitly set a width)
stay stuck at the previously set width. I want to remove that setting
so the next time I invoke Format / Column / Standard Width, *all*
columns will change width. How?

- Rich

 

[John Thow]

Apparently what I want wasn't clear to some, so let me try again.
If I invoke Format / Column / Standard Width, and enter a new value,
then most (but not all) of my columns change width to the new value.
Some (those columns for whom I had previously explicitly set a width)
stay stuck at the previously set width. I want to remove that setting
so the next time I invoke Format / Column / Standard Width, *all*
columns will change width. How?

- Rich

Select the sheet first, then do the format. That'll change all columns to
your new 'standard' width.
--
John Thow
an optimist is a guy/ that has never had/ much experience -
certain maxims of archie; Don Marquis.

To e-mail me, replace the DOTs in the Reply-To: address with dots!

 

[Don Guillett]

If this difference is not clear to you, please don't cloud the issue.


Define the default column width
1.. Right-click a sheet tab, and then click Select All Sheets on the
shortcut menu
2.. On the Format menu, point to Column, and then click Standard Width.
3.. Type a new measurement.
The number that appears in the Standard column width box is the average
number of digits 0-9 of the standard font that fit in a cell.

To define the default column width for all new workbooks and worksheets,
create a workbook template and a worksheet template.

Sub SetColWidths()
x = ActiveSheet.StandardWidth
Sheets.Select
Sheet1.Activate
ActiveSheet.Cells.Select
Selection.ColumnWidth = x
Sheet1.Select
End Sub

 

[Rich Pasco]

Define the default column width
1.. Right-click a sheet tab, and then click Select All Sheets on the
shortcut menu
2.. On the Format menu, point to Column, and then click Standard Width.
3.. Type a new measurement.
The number that appears in the Standard column width box is the average
number of digits 0-9 of the standard font that fit in a cell.

Yes, I know how to define the default (or "standard") column width.
You're telling me something I already know, and not answering my question.

What I don't know is how to remove the "custom" width that I have
applied to *some* columns, which prevents them from inheriting the
default ("standard") with set by your procedure above.

- Rich

 

[John Thow]

Select the sheet first, then do the format. That'll change all columns to
your new 'standard' width.
--

Ah, I see what you mean. Harlan's got it , I think.
--
John Thow
an optimist is a guy/ that has never had/ much experience -
certain maxims of archie; Don Marquis.

To e-mail me, replace the DOTs in the Reply-To: address with dots!