Forum Discussion

Copper Contributor

Mar 18, 2022

Solved

Adding a new formula to list

Morning, I have a preferred formula that I use in Excel, so I have it on a post-it and have to copy it in Excel everytime that I open a new excel file. How do I get this formula: _(* #,##0.00_);[R...

Formulas and Functions

NikolinoDE
Mar 18, 2022
Hanlie_Engelbrecht
Perhaps it could go with this workaround... predefine and use as a standard template.
...is just a thought 🙂
Save cell styles to use in all new workbooks
If you want to make the cell styles that you create in or copy into a workbook available in all future workbooks, you can save them in a template that is used for all new workbooks.
After you exit and restart Excel, the cell styles that you saved in your template workbook will be available in all new workbooks that you create.

Hope I was able to help with this info.

NikolinoDE
I know I don't know anything (Socrates)

NikolinoDE

Platinum Contributor

Mar 18, 2022

Hanlie_Engelbrecht

Perhaps it could go with this workaround... predefine and use as a standard template.

...is just a thought 🙂

Save cell styles to use in all new workbooks

If you want to make the cell styles that you create in or copy into a workbook available in all future workbooks, you can save them in a template that is used for all new workbooks.

After you exit and restart Excel, the cell styles that you saved in your template workbook will be available in all new workbooks that you create.

Hope I was able to help with this info.

NikolinoDE

I know I don't know anything (Socrates)

Hanlie_Engelbrecht

Copper Contributor

Mar 19, 2022

Hi, This works like a bomb.... thank you soo much for this idea. Had to do it a couple of time, because I did not follow the steps right to the end, but eventually I woke up and realise that there are more steps. It is magic! Thank you so much.!