Formula Help Please

[Jim]

I want to add a new worksheet and need to copy the formulas from the old one to the new one.
How do I do this?

Thanks

Jim

 

[Philip Reece-Heal]

If you mean a new Worksheet in the same Workbook:

Select the range of cells you want to copy, on the Menu bar click Edit then Copy. Click Insert then Worksheet to open new worksheet. Select the top left position for your data on this new worksheet and then click Edit then Paste Special and from the box that appears, click formulas. This will copy formulas with no data

Best of luck
Philip

 

[Jim]

Phillip:

I did exactly as you stated and it copied everything, data included. I "did" click formulas.

Jim


If you mean a new Worksheet in the same Workbook:

Select the range of cells you want to copy, on the Menu bar click Edit then Copy. Click Insert then Worksheet to open new worksheet. Select the top left position for your data on this new worksheet and then click Edit then Paste Special and from the box that appears, click formulas. This will copy formulas with no data

Best of luck
Philip

 

[Gord Dibben]

Jim

Right-click on the sheet tab. Select "move or copy".

Check in "create a copy".

Decide where you want it placed in the workbook and OK.

Now, in the copy, CRTL + A to select all cells.

Edit>Go To>Special>Constants. Uncheck what you want to keep and OK.

With the Constants highlighted Edit>Clear Contents.

Re-name the sheet.

Gord Dibben Excel MVP

 

[Jim]

Gord:
Thanks for your help, had to try it a few times but finally got it.
Appreciate the help.

Jim

"Gord Dibben" <gorddibbATshawDOTca> wrote in message Jim

Right-click on the sheet tab. Select "move or copy".

Check in "create a copy".

Decide where you want it placed in the workbook and OK.

Now, in the copy, CRTL + A to select all cells.

Edit>Go To>Special>Constants. Uncheck what you want to keep and OK.

With the Constants highlighted Edit>Clear Contents.

Re-name the sheet.

Gord Dibben Excel MVP

 

[Gord Dibben]

Jim

Thanks. Aren't you happy you used a copy of the workbook to experiment with!

Gord