you could do it one of two ways. one would be a macro, such as this:

Sub format()
Dim ws as Worksheet

For Each ws In ActiveWorkbook.Worksheets
ws.Range("a1").Font.Bold = True
Next ws

End Sub


the other way would be to select all the worksheets manually, complete
your formatting, and then unselect them.

hope that helps!
:)
susan


On Jan 8, 11:37*am, "Saucer Man" wrote:
I have a workbook with 12 worksheets. *It is still in develoment so I am
making changes to the formatting to get it the way I want. *The changes I
make are on the active sheet. *How do I apply the changes to all the sheets
so I don't have to delete them and then Copy the current sheet 11 times
everytime I make a change?

--
Thanks!