Another option too is format one sheet just the way you like it without any
data in it. Then once you know for sure, or have been given approval by
whomever you're working with, just right click the tab and say Copy. Then
you'll have Sheet1(2), Sheet1(3), etc. Of course, if you're working on
formatting after the fact of data entry, the other suggestion is good too.

"EBrock" wrote:

I want to create a workbook that has all worksheets formatted in the same
manner. Is there anyway to do so without formatting each worksheet
separately ?