Formatting several worksheets the same
 

I have created one worksheet with different size column widths and some cells
have different size font sizes. I need to have the same titles and format on
about 60 other worksheets (tabs). Is there a way to copy the format and
make-up of the first sheet to match the other 60 + sheets? Also, there are
formulas in the first sheet I would like to have copied as well.

Formatting several worksheets the same
 

Right-click on one sheet and "Select all sheets".

What you do to one will be done to all.

Note: if you don't already have the 60 sheets you could just use a macro to make
59 copies of the first one which would be formatted as you wished.


Gord Dibben MS Excel MVP

On Fri, 22 Feb 2008 08:22:02 -0800, heater
wrote:

I have created one worksheet with different size column widths and some cells
have different size font sizes. I need to have the same titles and format on
about 60 other worksheets (tabs). Is there a way to copy the format and
make-up of the first sheet to match the other 60 + sheets? Also, there are
formulas in the first sheet I would like to have copied as well.