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

Ask a question Mflores81 1Posts Tuesday May 3, 2016Registration date May 3, 2016 Last seen - Latest answer on May 4, 2016 03:26AM
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 
moins plus
Here is info from Microsoft on creating a template:

Good Luck
Add comment
moins plus
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.

Add comment

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!