Learn › Excel › Strikethrough text
Excel strikethrough shortcut: Ctrl + 5
Draw a line through the text in a cell, and take it off with the same keys.
With voice. Recorded in Excel for the web; the shortcut works the same in desktop Excel. Recorded on a US keyboard. On other keyboards some keys differ: see the table below the video.
Keys on keyboards of other languages
The video is recorded on an English (US) keyboard. This is how the same shortcut is pressed on the keyboards of the other languages. The highlighted row is your language.
* Based on the keyboard layout, not tested on a real keyboard (only the Croatian one was tested). If the shortcut does not work, use the matching button on the ribbon.
What it does
Ctrl + 5 applies strikethrough to the selected cells, or to the selected words while you edit a cell. The text stays in the cell and is still a normal value, it just looks crossed out. Press the shortcut again to remove the line.
When to use it
Use it for to-do lists, finished tasks, old prices and anything that is done or no longer valid but should stay visible. Select a whole row with Shift + Space to cross out everything on that row at once.
How to do it
- Click the cell with the finished task, or select several cells.
- Press Ctrl + 5 (on a Mac: Command + Shift + X).
- A line goes through the text. Press the same keys again to remove it.
A quick example
You keep a task list in column A. When you finish Order printer paper, click that cell and press Ctrl + 5. The task is crossed out but still there. To cross out the whole row, press Shift + Space first, then Ctrl + 5.
Ctrl + 5 and the Font settings
Ctrl + 5 is the same as ticking Strikethrough in the Font options, which you can open with Ctrl + 1. If you only want part of a cell crossed out, press F2 first, select the words with Shift and the arrow keys, and then press Ctrl + 5. The line is only a format, so a formula or a sum still counts the cell.
Shortcuts mentioned on this page, with video:
Not working? Check this
- Nothing happens: click into the sheet first, not into the formula bar or a search box.
- On a Mac the shortcut is Command + Shift + X, not Control + 5.
- The line disappeared: if you pressed the shortcut twice, strikethrough is off again. Press it once more.
- Ctrl + 5 does nothing on your laptop: use the number 5 on the row above the letters, not on the numeric keypad.
Quick answers
What is the shortcut for strikethrough in Excel?
Press Ctrl + 5 on Windows and Command + Shift + X on a Mac. Press it again to remove the line.
Can I strike through only part of a cell?
Yes. Press F2 to edit the cell, select the words with Shift and the arrow keys, then press Ctrl + 5. Only the selected words are crossed out.
How do I cross out a whole row?
Click a cell in the row, press Shift + Space to select the row, then press Ctrl + 5. Every cell in the row gets the line.

