Copy formulas from one sheet to another all at once [Solved/Closed]

Posts
1
Registration date
Tuesday May 3, 2016
Last seen
May 3, 2016
- May 3, 2016 at 03:39 PM - Latest reply:
Posts
1204
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
November 11, 2018
- May 4, 2016 at 03:26 AM
Is it possible to copy formulas from one sheet to another all at once? I have a worksheet that I would like to use as a template and I'm having to copy each of the cells formulas one by one. Please help, slowing productivity.
See more 

2 replies

Posts
19477
Registration date
Wednesday October 8, 2008
Status
Moderator
Last seen
November 19, 2018
May 3, 2016 at 06:10 PM
Posts
1204
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
November 11, 2018
May 4, 2016 at 03:26 AM
0
Thank you
Hello Mflores81 and xpcman,

Apologies for intruding but I believe that, on reading the first post, the OP already has a main sheet which he/she would just like to treat as a template sheet and just copy. So I would say that the simplest method would be:-

- Right click on the main sheet tab.
- From the menu that appears select "Move or Copy".
- From the "Move or Copy" dialogue box that appears, tick the "Create a Copy" box.
- Click OK.

This will make an exact copy of the main sheet with all formulae intact. Just rename the new sheet to suit.

I hope that this helps.

Cheerio,
vcoolio.