Apr 22 2021 05:38 AM
I often work in another currency than the standard US$, British pound, Euros, Swiss Franc. In other words every time I need to format cells I need to perform 4 steps to get to i.e. Russian Rubles.
Is there a shortcut to this currency formatting?
Apr 22 2021 07:51 AM
You could create a custom style for each currency. The style will be listed in Cell Styles in the Styles group of the Home tab of the ribbon.
You could also create macros that apply a specific currency format, and assign keyboard shortcuts to those macros.
May 03 2021 03:26 AM
May 03 2021 04:03 AM
You could create a blank workbook with the new style and save it as the default template for new workbooks. See How to set a default template in Excel
This will work for new workbooks that you create by pressing Ctrl+N or by clicking New on the Quick Access Toolbar. It won't work for existing workbooks that don't have the custom style.