Hi,
Method1: Case: Base Sheet exists & New sheets are not created yet.
-----------
Once you have formatted a sheet and want to create a new sheet with same
formatting, right-click the tab of the sheet, choose 'Move or Copy' from the
shortcut menu, the dialog pops-up. There, make sure check the 'Create a copy'
at the bottom of the dialog. Click OK.
It will create an identical sheet (formatting + contents). If there is data
you want to remove in the new sheet select the cels and go to menu Edit
Clear Contents.

Method2: Case: Sheets already exists, want to modify format.
-----------------------------------------------------------------------
You want to make some formatting changes. Say you have sheet1 through
sheet10. Select all sheet together: select sheet1 tab, hold the SHIFT key,
select the last sheet. You'll see all sheet tab being selected. From now on,
any change you make on the Active (visible sheet) will be applied to all
selected sheets.
To ungroup them: if all were selected, click one of their tab. If many (but
not all sheets) were selected, click one of the unselected sheet tab.
Actions on multiple sheets is feasible programmatically with:
worksheets(Array("sheet1","sheet2","sheet3"))...

Method3: Case: Base sheet already exists and is formatted , want to appply
format of base sheet to other existing sheets.
-----------------------------------------------------------------------
- select all sheets by selecting the base sheet first so that it is the
ActiveSheet
(selecting all sheets together: see Method2)
-select the columns, menu Edit Copy, then menu Edit PasteSpecial -
Formats only over themselves.
-same with rows
-same with whole cells
-If you need to copy the page setup too, go to menu File Page Setup, the
dialog pops-up, click OK

I hope this helps.
Sebastien

"JoAnne" wrote:

Is there a way to format multiple worksheets in one file the same, without
having to go to each worksheet separately to do?