How to Strikethrough in Excel

Last Updated: March 29, 2019 Tested

This wikiHow teaches you how to add the strikethrough effect (a line through your text) in Microsoft Excel. This feature is not available in the free Office Online version of Excel. ^{[1]
X
Research source}

Method 1

Method 1 of 2:

Using a Keyboard Shortcut

Download Article

You can usually do this by double-clicking the file name on your computer.
You can select an entire cell, multiple cells, or just some of the text within a single cell. ^{[2]
X
Research source}

Advertisement
3
Press Ctrl + 5 . The selected text now appears crossed-out ~~like this~~ . ^{[3]
X
Research source}
- To remove this effect, select the text, and then use the keyboard shortcut once more.
- You may need to use ⌘ Command + ↑ + X on some computers instead of Ctrl + 5 .

Method 2

Method 2 of 2:

Using Cell Formatting

Download Article

You can usually do this by double-clicking the file name on your computer.
If you only want to use strikethrough on some of the text within a cell, see this method instead.
A menu will appear.
The Format Cells dialog box will appear.
It’s near the top of the dialog box.
It’s in the “Effects” section.
7
Click OK . This crosses-out the values of the selected cells. The text within the cells now appears crossed-out ~~like this~~ .
- To remove this effect, return to the Format Cells dialog box, remove the check mark from "Strikethrough," and then click OK .