Formatting several worksheets the same

H

heater

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.
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code to format cells on several worksheets 2
Need to merge worksheets - Excel 2003 0
Locked Several Worksheets, allow format cells/select unlocked cell 2
Copying Formatting from one Worksheet to another within different 4
FORMATTING CELLS 3
How do I protect several worksheets at the same time? 5
Entering same header & or footer into several worksheets 2
How do I change the size of a worksheet? 3

Top