Currency format will add your regional currency symbol, put in comma separators for thousands, millions etc, and display two decimal places. It will also display red text for negative numbers.
To set Currency format, select the cells and press Control + Shift + $
As mentioned before, Screen Reader users can get format details for a cell by pressing the Screen Reader key + F.
Thanks to Excel Campus for the graphic in this week’s shortcut.
Leave a Reply