200 Excel Shortcuts for PC and Mac

Learn Microsoft Excel Download PDF

Format cell value with currency formatting – Microsoft Excel shortcut

In financial mode? This shortcut changes the format within all selected cells to a currency-based format. When used shortcut will add a dollar sign and a decimal point followed by two zeros to any numbers within your selection. (I.E. $100.60)

Ctrl Shift $

Control Shift $

Get more Reference tips and tricks

Subscribe to our email updates and get Reference tips direct to your inbox.