Ctrl + BBold for headers and totalsThe most-used text formatting shortcut in Excel. Use it to establish visual hierarchy.
Text emphasis may seem minor, but it directly shapes how readers scan your document. The three core shortcuts are easy to learn and immediately useful.
Shortcuts you will master in this article
Ctrl + B / Ctrl + U / Ctrl + I
Every spreadsheet has cells that need to stand out — headers, totals, warnings. Clicking the ribbon button for each one interrupts the pace of formatting.
Ctrl+B, Ctrl+U, and Ctrl+I are intuitive by design (Bold, Underline, Italic), which means you'll start using them automatically almost immediately.
Keep decoration purposeful — assign each type a role and stick with it for a consistent look.
Ctrl + BBold for headers and totalsThe most-used text formatting shortcut in Excel. Use it to establish visual hierarchy.
Ctrl + UUnderline for critical itemsEffective for deadlines, required fields, or anything that demands immediate attention.
Ctrl + IItalic for notes and annotationsA lighter emphasis — good for supplementary information that shouldn't compete with primary content.
F4Repeat the same emphasis elsewhereFor scattered cells that all need the same formatting, F4 after one application is faster than repeating manually.
Excel Shortcut Practice
Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the shortcuts from this article and build lasting muscle memory.
Visit each shortcut detail page to see key positions and usage tips.
| Key | Action |
|---|---|
Ctrl + B | Bold |
Ctrl + U | Underline |
Ctrl + I | Italic |
F4 | Repeat Last Action |
A. Yes, but the combined weight can be visually heavy. Consider whether both are necessary, or whether one alone is sufficient.
A. Set the formatting once, then use F4 to repeat it as you move from header to header.
A. Yes — column widths, number formats, and table structure first. Get the skeleton right before adding decorative formatting.
A. Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the keys and switch between difficulty, category, and review practice for faster retention.