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

Report
Posts
1
Registration date
Tuesday May 3, 2016
Status
Member
Last seen
May 3, 2016
-
Posts
1260
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
February 3, 2020
-
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.

2 replies

Posts
19674
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
6,314
Posts
1260
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
February 3, 2020
212
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.