Strikethrough shortcut
Select the cells and press Ctrl+5 to draw a line through the text; press it again to remove it. On a Mac use Cmd+Shift+X. It's handy for to-do lists and marking items done without deleting them.
Try it: press the keys on this sheet
Windows and Mac keys
| Action | Windows | Mac |
|---|---|---|
| Strikethrough | Ctrl+5 | ⌘⇧X |
| Bold | Ctrl+B | ⌘B |
| Italic | Ctrl+I | ⌘I |
| Underline | Ctrl+U | ⌘U |
Shortcut not working?
Ctrl+5 does nothing
Use the 5 on the main number row, not the number pad. On some keyboards you may need to turn off a language or input shortcut that uses Ctrl+5.
Only part of the text is struck through
In edit mode (F2) the shortcut applies only to the selected characters. Press Esc and select the whole cell instead.
I want strikethrough to happen automatically
Use Conditional Formatting with a formula, for example =$C2="Done", and set the font to strikethrough.
Frequently asked questions
What is the strikethrough shortcut in Excel?
Ctrl+5 on Windows and Cmd+Shift+X on Mac. Press it again to remove the line.
How do I remove strikethrough in Excel?
Select the cells and press the same shortcut again, or open Format Cells with Ctrl+1 and untick Strikethrough on the Font tab.
What are the bold, italic and underline shortcuts?
Ctrl+B, Ctrl+I and Ctrl+U on Windows; Cmd+B, Cmd+I and Cmd+U on Mac.