Setting column widths the same on multiple worksheets
 

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

Setting column widths the same on multiple worksheets
 

Try

Copy|Paste special
Select formats
OK

Mike

"John" wrote:

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

Setting column widths the same on multiple worksheets
 

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.
--
Gary''s Student - gsnu200780


"John" wrote:

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