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.
Using the Font dialog box
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:
- Select the cell(s) containing the text you want to strike through.
- Right-click on the selected cell(s) and choose "Format Cells" from the context menu.
- In the Format Cells dialog box, click on the "Font" tab.
- Under "Effects," check the box next to "Strikethrough."
- Click "OK" to apply the strikethrough effect to your selected text.
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:

- Select the cell with the strikethrough effect you want to copy.
- Right-click on the selected cell and choose "Format Painter" from the context menu.
- 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:
- Enter the following formula in the cell where you want the strikethrough effect: `=CHAR(173)&"Your Text Here"`
- Replace "Your Text Here" with the text you want to strikethrough.
- 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.
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:

- Select the cell containing the text you want to format.
- Right-click on the selected cell and choose "Format Cells" from the context menu.
- In the Format Cells dialog box, click on the "Number" tab.
- Under "Category," choose "Custom."
- 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.