Strikethrough Text in Excel (Ctrl + 5)
The Strikethrough Text shortcut in Excel allows you to draw a line through selected text or numbers. It is commonly used to indicate completed tasks, cancelled values, or outdated information.
| Platform | Shortcut |
|---|---|
| Windows | Ctrl + 5 |
| Mac | Cmd + Shift + X |
What Does Strikethrough Do in Excel?
Strikethrough formatting places a horizontal line through the center of text or numbers. It does not delete data—only changes its visual appearance.
How to Apply Strikethrough Using Keyboard Shortcut
- Select the cell or specific text you want to strike through.
- Press Ctrl + 5 (Windows) or Cmd + Shift + X (Mac).
- The strikethrough formatting is applied instantly.
How to Remove Strikethrough in Excel
Use the same shortcut again to remove the strikethrough formatting from the selected text.
Tips & Best Practices
- Strikethrough is useful for task lists and audit tracking.
- You can apply strikethrough to partial text inside a cell.
- Combine strikethrough with conditional formatting for automation.
Frequently Asked Questions
Does Ctrl + 5 delete the cell value?
No. It only applies formatting and does not remove or change the actual data.
Why doesn’t strikethrough work on Mac?
Excel for Mac uses a different shortcut. Use Cmd + Shift + X.
Can I apply strikethrough using the Font dialog?
Yes. Open the Font dialog with Ctrl + 1 and enable Strikethrough.