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
- - Latest reply: vcoolio
Posts
1236
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
March 1, 2019
- 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
19635
Registration date
Wednesday October 8, 2008
Status
Moderator
Last seen
March 19, 2019
8119
Posts
1236
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
March 1, 2019
220
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.