Molly

Right-click and "Move or Copy" select "create a copy".

Now clear all Constants from this sheet. EditGo ToSpecialConstants

One other method if you're doing this often.

Create a new workbook with one sheet.

Copy all formats/formulas from the existing worksheet to this one.

FileSave AsFile Type Excel Template (*.xlt)

Store in your XLSTART folder and this will be your InsertNew Worksheet
default.

Gord Dibben Excel MVP

On Fri, 29 Oct 2004 14:06:04 -0700, "Molly"
wrote:

I have a workbook containing multiple sheets with a certain format/formula
set up already. Now I want to add another worksheet and want the same format
to transfer. How do I do this?