The Ctrl + B, I, U guide
Select the cells and press Ctrl+B for bold, Ctrl+I for italic, Ctrl+U for underline (⌘ on a Mac). Each one is a switch: press it again and it goes off.
The shortcuts
| Windows | Mac | |
|---|---|---|
| Bold | Ctrl+B or Ctrl+2 | ⌘B |
| Italic | Ctrl+I or Ctrl+3 | ⌘I |
| Underline | Ctrl+U or Ctrl+4 | ⌘U |
They change every selected cell at once, so select first: a header row, a column of notes, a total. The B, I and U buttons on the Home tab do the same.
On and off
Each shortcut switches its format on, and the next press switches it off. Press it twice by accident and the header is back to plain; press it once more. If part of a range is already bold, look at the result after one press before pressing again.
Format the cells, not the whole sheet
Bold for headers and totals, italics for notes and comments, underline for the line above a total: a few cells each. Press Ctrl+A before Ctrl+B and the numbers turn bold too, and the headers no longer stand out.
Common mistakes
- Pressing twice. The second press undoes the first.
- Selecting too much. Only the cells that need it.
- Underline for headers in finance sheets. Many teams keep the underline for totals; bold is the usual header style.
For number formats (currency, percent, decimals) see number formats.
FAQ
- What is the shortcut for bold in Excel?
- Ctrl+B on Windows (Ctrl+2 also works), Command+B on a Mac. Press it again to remove bold.
- What are the shortcuts for italic and underline in Excel?
- Ctrl+I and Ctrl+U on Windows (or Ctrl+3 and Ctrl+4), Command+I and Command+U on a Mac.
- Why did Ctrl+B remove bold instead of adding it?
- The shortcut switches bold on and off. If the cells were already bold, or you pressed it twice, it turns bold off. Press it once more.



































































