ShortcutdrillExcel shortcuts / formatting / Underline
Underline in Excel: Ctrl+U (Mac: Cmd+U)
| Windows | Ctrl+U |
|---|---|
| Mac | Cmd+U |
| Group | formatting |
Drill: Underline a heading. Pro drill. Twenty-five drills are free.
What it does and when to use it
Ctrl+U toggles underline. Finance uses a single underline above a subtotal line and a double underline for a grand total, the accounting convention; Ctrl+U gives the single one.
The common mistake
Underlining a whole row of numbers when only the total needs it.
Related shortcuts
- Bold the selection Ctrl+B
- Italic Ctrl+I
- Format as currency Ctrl+Shift+4
- Thousands separators and two decimals Ctrl+Shift+1
- Format as percentage Ctrl+Shift+5
- The printable cheat sheet
Questions
How do I double underline?
There is no default shortcut. Alt, H, F, F opens Format Cells; choose Double from the Underline list, or use Alt, H, 3, D on newer versions.
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