This article was co-authored by wikiHow staff writer, Rain Kengly. Rain is a tech writer and editor for wikiHow with over 5 years of professional writing experience. In the past, Rain has worked with other creative writers as a Writing Tutor at San Francisco State University and has published gaming features, guides, and news articles for a variety of media outlets. Rain shares a lifelong passion for writing and gaming and is eager to grow alongside new tech inventions.
This article has been fact-checked, ensuring the accuracy of any cited facts and confirming the authority of its sources.
This article has been viewed 48,679 times.
Learn more...
Want to cross out text in Microsoft Excel? You can use the strikethrough effect (a line through your text) to do so. This can be done whether you're using the computer application or the online version in your web browser. Here's how to strikethrough in Excel using your Windows or Mac computer.
Strikethrough a Cell in Excel
To strikethrough text in Excel, select the cells you want to edit, and then use the keyboard shortcut Ctrl + 5 (Windows) or Cmd + Shift + X (Mac). If you're using the web version, select the cells you want to edit and right-click them. Then, select Format Cells > Strikethrough.
Steps
-
Open your spreadsheet in Microsoft Excel. You can usually do this by double-clicking the file name on your computer.
- This method will work on Windows and Mac computers. If you're using the web version, you'll need to use cell formatting instead.
-
Highlight the text you want to format. You can select an entire cell, multiple cells, or just some of the text within a single cell.[1]Advertisement
-
Press Ctrl+5. The selected text now appears crossed-out
like this.[2]- 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.
-
Highlight the cells containing text you want to format. If you only want to use strikethrough on some of the text within a cell, see this method instead.
- This method will work in any version of Excel, including the free version on the web.
-
Right-click the highlighted area. A menu will appear.
-
Click Format Cells. The Format Cells dialog box will appear.
-
Click the Font tab. It’s near the top of the dialog box.
-
Check the box next to “Strikethrough.” It’s in the “Effects” section.
-
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.
Expert Q&A
Tips
References
About This Article
Windows: Highlight the text and press Ctrl + 5.
macOS: Highlight the text and press Command + up-arrow + X.









