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

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

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


Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!