ShortcutdrillExcel shortcuts / editing / Bold the header and format the numbers
Bold the header and format the numbers in Excel: Ctrl+Shift+Right, Ctrl+B, Down, Ctrl+Shift+Down, Ctrl+Shift+4 (Mac: Cmd+Shift+Right, Cmd+B, Down, Cmd+Shift+Down, Control+Shift+4)
| Windows | Ctrl+Shift+Right, Ctrl+B, Down, Ctrl+Shift+Down, Ctrl+Shift+4 |
|---|---|
| Mac | Cmd+Shift+Right, Cmd+B, Down, Cmd+Shift+Down, Control+Shift+4 |
| Group | editing |
Drill: Tidy the report. Pro drill. Twenty-five drills are free.
What it does and when to use it
The tidy-up that every export needs: bold the header, then format the amount column. Five presses, no menus. The drills put the pieces together so the sequence becomes one motion.
The common mistake
Formatting the header along with the numbers by starting the column selection one row too high.
Related shortcuts
- Undo Ctrl+Z
- Fill down Ctrl+D
- Fill right Ctrl+R
- Clear the selection Delete
- Delete the row Shift+Space, Ctrl+-
- The printable cheat sheet
Questions
How do I format a report quickly?
Header first (Ctrl+Shift+Right, Ctrl+B), then each numeric column (Ctrl+Shift+Down and the number format key), then a bottom border on the header (Alt, H, B, O).
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