copy worksheet (keeping formats)

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" <[email protected]> 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" <[email protected]> wrote in message
news:[email protected]...
>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
>