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

Embed the same Excel multiple times 0
Consolidation Table from Different Excel Tabs with Different Format 1
Text in note pane of "normal" display suddenly much larger 1
Need Help with a VBA subroutine 0
Format column widths from one table to a separate table on same page 1
Code to format cells on several worksheets 2
Problem with MS Word paragraph and character styles: format getting messed up 2
Cannot copy worksheet to another file 2

Top