ShortcutdrillExcel shortcuts / formatting / Format as percentage
Format as percentage in Excel: Ctrl+Shift+5 (Mac: Control+Shift+5)
| Windows | Ctrl+Shift+5 |
|---|---|
| Mac | Control+Shift+5 |
| Group | formatting |
Drill: Format as percentages. Pro drill. Twenty-five drills are free.
What it does and when to use it
Ctrl+Shift+5 (Ctrl+%) formats the selection as a percentage with no decimals. The value does not change; 0.125 shows as 13%.
The common mistake
Typing 12.5 and formatting it as a percent, which gives 1250%. Enter the fraction, or type 12.5% directly.
Related shortcuts
- Underline Ctrl+U
- Format as currency Ctrl+Shift+4
- Thousands separators and two decimals Ctrl+Shift+1
- Format a serial number as a date Ctrl+Shift+3
- Clear the number format Ctrl+Shift+`
- The printable cheat sheet
Questions
How do I show one decimal on a percentage?
After Ctrl+Shift+5, Alt, H, 0 adds a decimal place. Or set 0.0% in Format Cells.
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