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

Mflores81 1 Posts Tuesday May 3, 2016Registration date May 3, 2016 Last seen - May 3, 2016 at 03:39 PM - Latest reply: vcoolio 1173 Posts Thursday July 24, 2014Registration dateModeratorStatus July 15, 2018 Last seen
- 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

xpcman 19109 Posts Wednesday October 8, 2008Registration dateModeratorStatus July 21, 2018 Last seen - May 3, 2016 at 06:10 PM
vcoolio 1173 Posts Thursday July 24, 2014Registration dateModeratorStatus July 15, 2018 Last seen - 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.