To strike through text in Excel, select the cell or cells and press Ctrl + 5 on Windows or Command + Shift + X on a Mac. Press the same shortcut again to remove the strikethrough. It draws a line through text, so you can cross off completed tasks without deleting anything. The desktop app has no Strikethrough button on the Home tab, but there are other ways to apply it, including automatically when a task is marked done. The steps work in Excel 2013, 2016, 2019, 2021 and Microsoft 365.
Method 1: Keyboard shortcut
- Select one or more cells. Hold Ctrl to select cells that are not next to each other.
- Press Ctrl + 5 (Windows) or Command + Shift + X (Mac).
Use the 5 key in the row above the letters, not the numeric keypad.
Why does Ctrl + 5 not work?
Make sure you are using the 5 above the letters, and that you are not in the middle of editing a cell with nothing selected. Some keyboard utilities also take over Ctrl + number shortcuts.
Can I strikethrough in Google Sheets or Word?
Yes. In Google Sheets the shortcut is Alt + Shift + 5. For other apps, see how to cross out a word in text and how to use strikethrough in Google Docs.
Method 2: Format Cells dialog box
- Select the cells.
- Press Ctrl + 1, or right-click and choose Format Cells.
- Open the Font tab.
- Under Effects, tick Strikethrough.
- Click OK.
The same tab lets you change the font color at the same time, for example making crossed-out items gray.
Method 3: Strike through part of a cell
- Double-click the cell, or select it and press F2, to edit it.
- Select just the words you want to cross out.
- Press Ctrl + 5, or press Ctrl + 1 and tick Strikethrough.
- Press Enter.
This only works for text typed into the cell, not for formula results.
If you prefer clicking, add the command to the Quick Access Toolbar:
- Click the arrow at the end of the Quick Access Toolbar and choose More Commands.
- Set Choose commands from to All Commands.
- Select Strikethrough, click Add, then OK.
In Excel for the web, a Strikethrough button (ab) is already on the Home tab in the Font group.
Method 5: Strike through automatically when a task is done
For a to-do list, conditional formatting can cross out a row when it is marked complete.
- Put your tasks in column A and a status in column B, such as “Done”, or insert checkboxes with Insert > Checkbox (available in Microsoft 365).
- Select the task cells, for example A2:A50.
- Go to Home > Conditional Formatting > New Rule.
- Choose Use a formula to determine which cells to format.
- Enter =$B2=”Done”, or =$B2=TRUE for checkboxes.
- Click Format, tick Strikethrough on the Font tab, and click OK twice.
Now tasks are crossed out the moment you type Done or tick the box, and the line disappears if you change it back.
Put a diagonal slash through a cell
If you want a line drawn corner to corner across a cell rather than through the text, use a border:
- Select the cell and press Ctrl + 1.
- Open the Border tab.
- Click one of the diagonal border buttons at the bottom corners of the preview.
- Click OK.
This is often used for header cells that label both rows and columns, or to show a cell as not applicable.
How to remove strikethrough
Select the cells and press Ctrl + 5 again, or untick Strikethrough in Format Cells. If the line keeps coming back, it is coming from a conditional formatting rule; check Home > Conditional Formatting > Manage Rules.
Need the same effect in a chat? See how to cross out text in WhatsApp, where a pair of tildes does the job.

Kermit Matthews runs Live2Tech from just outside Philadelphia. He is an IT specialist with over 20 years of experience, from a university help desk to small-business IT, IT management and his own consulting practice, and has written tech guides full time since 2020. Steps are checked against the current software on a real device or the maker’s official documentation. More about Kermit.