Setting column widths the same on multiple worksheets

  • Thread starter Thread starter John
  • Start date Start date
J

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
 
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.
 
Back
Top