Hi,

You may alternatively also right click on the sheet and then go the Move or
Copy. Please check the box for "Create a Copy"

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

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