"Mastering Excel: How to Strikethrough Text"

Angela Jun 16, 2026

Ever needed to cross out or strike through text in Excel to indicate that it's no longer relevant or to show a correction? While Excel doesn't have a built-in strikethrough feature like some word processors, you can achieve this effect using a simple trick. Here's how to strikethrough text in Excel.

How to Strikethrough Text in Excel - shortcut and example
How to Strikethrough Text in Excel - shortcut and example

Using the Font dialog box

How to Strikethrough Text in Word, Excel & PowerPoint
How to Strikethrough Text in Word, Excel & PowerPoint

The easiest way to strikethrough text in Excel is by using the Font dialog box. This method works in all versions of Excel. Here's how:

  1. Select the cell(s) containing the text you want to strike through.
  2. Right-click on the selected cell(s) and choose "Format Cells" from the context menu.
  3. In the Format Cells dialog box, click on the "Font" tab.
  4. Under "Effects," check the box next to "Strikethrough."
  5. Click "OK" to apply the strikethrough effect to your selected text.
the word strikethrough is displayed in front of an image of a cartoon character
the word strikethrough is displayed in front of an image of a cartoon character

Strikethrough text in multiple cells

If you want to strikethrough text in multiple cells, you can apply the strikethrough effect to one cell and then copy the formatting to the other cells. Here's how:

[Excel Learning] How to strikethrough text
[Excel Learning] How to strikethrough text
  1. Select the cell with the strikethrough effect you want to copy.
  2. Right-click on the selected cell and choose "Format Painter" from the context menu.
  3. Now, click on the cells where you want to apply the strikethrough effect.

Using the CHAR function

Another way to strikethrough text in Excel is by using the CHAR function. This method is useful when you want to strikethrough text within a formula or a cell reference. Here's how:

How to Strikethrough text in Word or Excel
How to Strikethrough text in Word or Excel
  1. Enter the following formula in the cell where you want the strikethrough effect: `=CHAR(173)&"Your Text Here"`
  2. Replace "Your Text Here" with the text you want to strikethrough.
  3. Press Enter, and you'll see the text with a strikethrough effect.

Understanding the CHAR function

The CHAR function returns the character represented by a specific code. In this case, the code 173 represents the strikethrough character. When you combine this character with your text, Excel displays the text with a strikethrough effect.

How to Strikethrough Text in Excel!
How to Strikethrough Text in Excel!

Formatting text as superscript or subscript

While not exactly strikethrough, you can also format text as superscript or subscript in Excel. This can be useful for indicating mathematical formulas or chemical elements. Here's how:

Strikethrough in Excel: How to Cross Out Text in Cells - Make Tech Easier
Strikethrough in Excel: How to Cross Out Text in Cells - Make Tech Easier
the format cells dialogg is highlighted in the text box above the font field
the format cells dialogg is highlighted in the text box above the font field
How to Wrap Text in Excel Step by Step
How to Wrap Text in Excel Step by Step
Excel tricks
Excel tricks
How to Strikethrough in Excel: 4 Simple and Workable Solutions
How to Strikethrough in Excel: 4 Simple and Workable Solutions
Common Excel Mistake: Sorting Names Incorrectly
Common Excel Mistake: Sorting Names Incorrectly
Excel Trick You Need
Excel Trick You Need
3 Excel Strikethrough Shortcuts to Cross Out Text or Values in Cells
3 Excel Strikethrough Shortcuts to Cross Out Text or Values in Cells
Excel Trick: Custom Sort How To do it!
Excel Trick: Custom Sort How To do it!
How to strike through selection| How to change the font and font size in MS Excel|#shortcut(L#7)
How to strike through selection| How to change the font and font size in MS Excel|#shortcut(L#7)
This new function 🤯
This new function 🤯
Tips for Working With Text and Text Functions in Excel
Tips for Working With Text and Text Functions in Excel
How to Strikethrough Text in Excel
How to Strikethrough Text in Excel
How to Copy from Excel to Word Without Losing Formatting (4 Easy Ways)
How to Copy from Excel to Word Without Losing Formatting (4 Easy Ways)
a screenshot of a computer screen with the text, loggle visual basic for applications
a screenshot of a computer screen with the text, loggle visual basic for applications
the top 15 excel formulas are written on lined paper with different symbols and numbers
the top 15 excel formulas are written on lined paper with different symbols and numbers
How to Use FORMULA TEXT Function in Excel
How to Use FORMULA TEXT Function in Excel
How to Write Vertical Text in Excel
How to Write Vertical Text in Excel
Master Excel in 30 Days: Your Roadmap to Data Mastery! 🚀
Master Excel in 30 Days: Your Roadmap to Data Mastery! 🚀
the different types of text and numbers in each language, including one for each subject
the different types of text and numbers in each language, including one for each subject
  1. Select the cell containing the text you want to format.
  2. Right-click on the selected cell and choose "Format Cells" from the context menu.
  3. In the Format Cells dialog box, click on the "Number" tab.
  4. Under "Category," choose "Custom."
  5. In the "Type" field, enter one of the following codes to format your text:
    • Superscript: `^0`
    • Subscript: `_0`

  • Click "OK" to apply the formatting to your selected text.
  • And there you have it! Now you know how to strikethrough text in Excel using two different methods. Whether you're indicating corrections, showing that text is no longer relevant, or formatting mathematical formulas, these techniques will help you make your Excel documents more engaging and easier to understand.