Would this work for you?

Create and format a sheet to your liking.
THEN,
Hold down <Ctrl,
Click on the sheet tab and drag to the right.
Release the mouse first, then release <Ctrl.

You now have an *exact* copy of that sheet.
Rename it as you please.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Kansas City Kitty" wrote in
message ...
Jimminy Cricket!!!!!!!!!!!!!1
there's got to be a way to format one worksheet and have that same format
be
reflected in additional worksheets as they are created. no macros, no
programming, no special tricks. just make it happen. So the cell formats,
colors, watermarks, fonts, etc. become part of the entire workbook.