"Mastering Excel: How to Strikethrough Text"

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:

  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.

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:

Strikethrough Text in Excel - How To Use? Methods and Examples.

  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:

  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.

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:

Workable Ways to Strikethrough in Excel Using Different Devices

  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`
  6. 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.

Strikethrough Text in Excel - How To Use? Methods and Examples.

Strikethrough Text in Excel - How To Use? Methods and Examples.

Workable Ways to Strikethrough in Excel Using Different Devices

Workable Ways to Strikethrough in Excel Using Different Devices

How to Strike Through Text in Excel - Xelplus - Leila Gharani

How to Strike Through Text in Excel - Xelplus - Leila Gharani

How to Strikethrough Text in Excel: Step-by-Step & Shortcut

How to Strikethrough Text in Excel: Step-by-Step & Shortcut

8 Ways To Strikethrough Text in Excel - Classical Finance

8 Ways To Strikethrough Text in Excel - Classical Finance

How to Strikethrough Text in MS Excel - OfficeBeginner

How to Strikethrough Text in MS Excel - OfficeBeginner

8 Ways To Strikethrough Text in Excel - Classical Finance

8 Ways To Strikethrough Text in Excel - Classical Finance

Workable Ways to Strikethrough in Excel Using Different Devices

Workable Ways to Strikethrough in Excel Using Different Devices

How to Strike Through Text in Excel - Xelplus - Leila Gharani

How to Strike Through Text in Excel - Xelplus - Leila Gharani

How to Strikethrough Text in Microsoft Excel | ITFixed Computer Services

How to Strikethrough Text in Microsoft Excel | ITFixed Computer Services

Workable Ways to Strikethrough in Excel Using Different Devices

Workable Ways to Strikethrough in Excel Using Different Devices

Excel Strikethrough Auf Text _ How to Filter by Strikethrough in Excel ...

Excel Strikethrough Auf Text _ How to Filter by Strikethrough in Excel ...

How to Strikethrough in Excel: 7 Methods (Shortcut, Conditional ...

How to Strikethrough in Excel: 7 Methods (Shortcut, Conditional ...

How to Strikethrough in Excel – 3 Ways!

How to Strikethrough in Excel – 3 Ways!

How to Strikethrough Text in Excel

How to Strikethrough Text in Excel

Workable Ways to Strikethrough in Excel Using Different Devices

Workable Ways to Strikethrough in Excel Using Different Devices

How to Strikethrough in Excel: 8 Ways

How to Strikethrough in Excel: 8 Ways

Strikethrough in Excel (Examples) | How to Strikethrough?

Strikethrough in Excel (Examples) | How to Strikethrough?

How To Add Strikethrough Button In Excel

How To Add Strikethrough Button In Excel

How to strikethrough text in excel – Healthy Food Near Me

How to strikethrough text in excel – Healthy Food Near Me