Setting column widths the same on multiple worksheets

[John]

I have a workbook w/ sheets of data for every month. I have adjusted column
widths on my January sheet. Now I want to set all the columns on the other
sheets to the same width as the corresponding columns on the January sheet.
Is there some way to copy multiple column width settings from one sheet to
another?

Thx for your help, John

 

[Mike H]

Try

Copy|Paste special
Select formats
OK

Mike

 

[Gary''s Student]

Here is a neat trick! Say January is just the way you want it. When it
comes time to add the May sheet, do not:

Insert > Worksheet

instead, start on the January sheet and:

Edit > Move or copy worksheet >

then re-name the new sheet to May and clear the contents. All the columns
will be just as you want them.