Formula Help Please

  • Thread starter Thread starter Jim
  • Start date Start date
J

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
 
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
 
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
 
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:
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
 
Jim

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

Gord
 
Back
Top