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
1292
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
May 7, 2021
-
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.
Related:

2 replies

Posts
19532
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
1,818
Posts
1292
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
May 7, 2021
230
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!