Copy formulas from one sheet to another all at once
Solved/Closed
Mflores81
Posts
1
Registration date
Tuesday May 3, 2016
Status
Member
Last seen
May 3, 2016
-
May 3, 2016 at 03:39 PM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - May 4, 2016 at 03:26 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - May 4, 2016 at 03:26 AM
Related:
- Copy formulas from one sheet to another all at once
- How to transfer data from one sheet to another in excel using formula - Guide
- Little alchemy cheat sheet - Guide
- Google sheet right to left - Guide
- How to screenshot excel sheet - Guide
- Cmd network commands cheat sheet - Guide
2 responses
xpcman
Posts
19530
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
1,827
May 3, 2016 at 06:10 PM
May 3, 2016 at 06:10 PM
Here is info from Microsoft on creating a template:
https://support.microsoft.com/en-us/office/save-a-workbook-as-a-template-58c6625a-2c0b-4446-9689-ad8baec39e1e?ui=en-us&rs=en-us&ad=us
Good Luck
https://support.microsoft.com/en-us/office/save-a-workbook-as-a-template-58c6625a-2c0b-4446-9689-ad8baec39e1e?ui=en-us&rs=en-us&ad=us
Good Luck
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
May 4, 2016 at 03:26 AM
May 4, 2016 at 03:26 AM
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.
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.
