I know I've found and save the answer to this question but I can't seem to
locate it.

I want to copy a worksheet and create another worksheet within the same
workbook and keep all it's formats and formulas. I will be changing some of
the formulas later, but will keep the formats.

Thanks,

Ken

Ken

Right-click on sheet tab and "move or copy".

Check "create a copy" and OK.

You have an exact duplicate of the sheet named Sheet(2)


Gord Dibben Excel MVP

On Wed, 16 Feb 2005 00:04:01 GMT, "Ken" wrote:

I know I've found and save the answer to this question but I can't seem to
locate it.

I want to copy a worksheet and create another worksheet within the same
workbook and keep all it's formats and formulas. I will be changing some of
the formulas later, but will keep the formats.

Thanks,

Ken

If you right-click on the worksheet's tab, and select "Move or Copy", check
the "create a copy" checkbox and click "OK" might do what you want.

Thank you. I will make note of this and PUT IT WHERE I CAN FIND IT THIS
TIME.
Again thanks for your time.
Ken Williams

"Ken" wrote in message
ink.net...
I know I've found and save the answer to this question but I can't seem to
locate it.

I want to copy a worksheet and create another worksheet within the same
workbook and keep all it's formats and formulas. I will be changing some
of the formulas later, but will keep the formats.

Thanks,

Ken