How to Strikethrough Text in Excel

Strikethrough draws a line through text, like this. It’s handy for marking tasks as done or showing something that was removed, while keeping it readable.

From Format Cells

1. Select cells B4 and B5.

2. Right-click and click Format Cells.

   

3. On the Font tab, tick Strikethrough.

   

4. Click OK.

   

With the keyboard

1. Select cell B7.

2. Press Ctrl + 5.

   

Press Ctrl + 5 again to remove it.

Cross out only part of a cell

1. Select the cell, then select just the words to cross out, in the formula bar or after double-clicking the cell.

   

2. Press Ctrl + 5.

   

Add a Strikethrough button

If you use it a lot, add a button to the Quick Access Toolbar:

1. Click the small down arrow at the end of the Quick Access Toolbar.
2. Click More Commands.
3. Under Choose commands from, select Commands Not in the Ribbon.
4. Select Strikethrough and click Add.
5. Click OK.

For pictures of these steps, see How to Customize the Quick Access Toolbar.