How do I format all worksheets in a workbook at one time ?

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 ?

yes,
Right click on any sheet tab, Select "Select All Sheets" from the pop-up menu.
Have fun formatting the active sheet. When done take a look at any sheet and
the formatting is done on ALL the selected sheets.

Dan Knight

"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 ?

Dan, left out the most important part. (i.e. WARNING: sever tire damage)

When you have formatted all of the sheet, you must *ungroup* the sheets
as any change you make to one you see, you make to all in the group.
Right-click any worksheet tab and "Ungroup sheets". With practice
you will learn to can also ungroup by clicking outside a smaller grouping
of sheets.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Dan Knight" <[email protected]> wrote in message news:[email protected]...
> yes,
> Right click on any sheet tab, Select "Select All Sheets" from the pop-up menu.
> Have fun formatting the active sheet. When done take a look at any sheet and
> the formatting is done on ALL the selected sheets.
>
> Dan Knight
>
> "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 ?

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 ?