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
How do I do this?
Thanks
Jim
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
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
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
J
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
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
G
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
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
J
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
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
G
Gord Dibben
Jim
Thanks. Aren't you happy you used a copy of the workbook to experiment with!
Gord
Thanks. Aren't you happy you used a copy of the workbook to experiment with!
Gord