ShortcutdrillExcel shortcuts / formatting / Format as currency
Format as currency in Excel: Ctrl+Shift+4 (Mac: Control+Shift+4)
| Windows | Ctrl+Shift+4 |
|---|---|
| Mac | Control+Shift+4 |
| Group | formatting |
Drill: Format as currency. Pro drill. Twenty-five drills are free.
What it does and when to use it
Ctrl+Shift+4 (Ctrl+$) applies the currency format with two decimals and thousands separators. Select the column with Ctrl+Shift+Down first and the whole thing formats at once.
The common mistake
Trying Cmd+Shift+4 on a Mac, which takes a screenshot. Use Control, not Cmd, for the number formats on a Mac.
Related shortcuts
- Italic Ctrl+I
- Underline Ctrl+U
- Thousands separators and two decimals Ctrl+Shift+1
- Format as percentage Ctrl+Shift+5
- Format a serial number as a date Ctrl+Shift+3
- The printable cheat sheet
Questions
How do I change which currency symbol Ctrl+Shift+4 uses?
It follows the system locale. For another currency, open Format Cells with Ctrl+1 and pick it under Currency.
Learn it by pressing it
Shortcutdrill gives you a task on a live sheet and a limit on key presses, so the shortcut has to become a reflex. Twenty-five drills are free; Pro unlocks all 80 for $9 a month, $29 a year, or $49 once.
Start the drill