1
Ctrl + BBold for headers and totals
The most-used text formatting shortcut in Excel. Use it to establish visual hierarchy.
BoldUnderlineItalic
Apply Bold, Underline, and Italic in Excel Using Only the Keyboard
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
Reaching for the Ribbon for Text Formatting Breaks Your Flow
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.
How to Use the Three Emphasis Shortcuts
Keep decoration purposeful — assign each type a role and stick with it for a consistent look.
2
Ctrl + UUnderline for critical items
Effective for deadlines, required fields, or anything that demands immediate attention.
3
Ctrl + IItalic for notes and annotations
A lighter emphasis — good for supplementary information that shouldn't compete with primary content.
4
F4Repeat the same emphasis elsewhere
For scattered cells that all need the same formatting, F4 after one application is faster than repeating manually.
Excel Shortcut Practice
Master Excel shortcuts and
gain real productivity skills
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.
Practical Rules for Text Emphasis
Assign each format type a consistent purpose (e.g., bold = header, italic = footnote) for a more polished result.
Underline used sparingly is effective; overused, it becomes visual noise.
Limit the number of emphasis types in any one document — variety reduces, rather than increases, clarity.
Related Shortcuts
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 |
Frequently Asked Questions
Q. Can I combine bold and underline on the same cell?
A. Yes, but the combined weight can be visually heavy. Consider whether both are necessary, or whether one alone is sufficient.
Q. What's the fastest way to apply consistent header formatting across a sheet?
A. Set the formatting once, then use F4 to repeat it as you move from header to header.
Q. Is there anything I should format before text emphasis?
A. Yes — column widths, number formats, and table structure first. Get the skeleton right before adding decorative formatting.
Q. How do I memorize Excel shortcuts faster?
A. Reading alone won't make them stick. Use KeyboardGym's Excel practice mode to actually type the keys and alternate between sequential and random practice for faster retention.
Excelスキルを年収アップにつなげる方法 — 転職・評価アップへの活かし方を解説
解説記事を読む →