Mar 17 2022 11:19 PM
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_);[Red]_(* (#,##0.00);_(* "-"??_);_(@_)
to always be available in this list of pre-defined options:
Here I will now get my formula and paste it here, but I need to do it every time that I work on a new excel file. Can I not make this my default use.
Please help.
Mar 17 2022 11:55 PM
Mar 18 2022 12:33 AM
@Starrysky1988
Thanks a million for the explanation. Maybe if I understood the actual formula better it would have been easier. This will make it easier for me.
Thanks.
Mar 18 2022 12:45 AM
SolutionPerhaps 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.
I know I don't know anything (Socrates)
Mar 18 2022 11:16 PM
Mar 18 2022 12:45 AM
SolutionPerhaps 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.
I know I don't know anything (Socrates)