Strikethrough In Excel

What Is Strikethrough In Excel?

The Strikethrough in Excel is a font feature where a horizontal line appears at the center of the cell. The line is a strike or a cross through any value in the cell. Using Strikethrough in Excel in a cell indicates that the text or a character with a strike can be ignored or removed.

Key Takeaways
  • The Strikethrough in Excel is a feature that strikes through the words in the cells.
  • There are many methods to insert a Strikethrough in Excel in a cell, and the simplest is by using the Strikethrough shortcut Excel keys, i.e., “Ctrl+5”.
  •  Irrespective of the methods we use to apply Strikethrough in Excel, we can always use the Strikethrough shortcut Excel keys “Ctrl+5” to remove Strikethrough In Excel].

Top Six Methods To Strikethrough In Excel

We will use Strikethrough in Excel in six different ways, namely,

  1. Using Excel Shortcut Key.
  2. Using Format Cell Options.
  3. Using from Quick Access Toolbar.
  4. Using it from Excel Ribbon.
  5. Using Dynamic Conditional Formatting.
  6. Using VBA.

#1 – Using Excel Shortcut Key

We will understand Strikethrough text Excel using the Excel shortcut keys [Ctrl+5].

In the table, the data is as follows:

  • Column A contains the Sample Text for Strikethrough.
Strikethrough in Excel Example 1

The steps to Strikethrough in Excel using the Excel shortcut keys are,

Step 1: Select the cells A3 and A4.

Strikethrough in Excel Example 1.1

Step 2: Press the shortcut key CTRL+5. The output is shown below.

Example 1.2

#2 – Using Format Cell Options

We will understand Strikethrough text Excel using the Format cells options.

In the table, the data is as follows:

  • Column A contains the First Name.
  • Column B contains the Last Name.
  • Column C contains the Street.
  • Column D contains the City.
  • Column E contains the State.
  • Column F contains the Postal Code.
Strikethrough in Excel Example 2

The steps to Strikethrough in Excel using the Format Cells option are,

Step 1: Select the cell range A2:F3.

Example 2.1

Step 2: Select the “Home” tab > go to the “Font” group > click on the “Font Settings” launcher. [Alternatively, we can use the shortcut keys Ctrl+Shift+F].

 Example 2.2

Step 3: Now, the “Format Cells” window opens. Under the “Font” menu, check/tick the “Strikethrough” checkbox in the “Effects” option.

Example 2.3

Step 4: Click on “OK”. The output is shown below.

Example 2.4

#3 – Using From Quick Access Toolbar

We will understand Strikethrough text Excel using the Quick Access Toolbar.

In the table, the data is as follows:

  • Column A contains the First Name.
  • Column B contains the Last Name.
  • Column C contains the Full Name.
Strikethrough in Excel Example 3

The steps to Strikethrough in Excel using the Quick Access Toolbar are,

Step 1: Select the File” tab > go to the More…options from the menu > select theOptionsas shown below.

File Options

Step 2: The Excel Optionswindow opens. Now, select the Customize Ribbonoption on the left side menu of the Excel Options window, as shown below.

Customize Tab2

Step 3: On the right side, in the “Main tabs” window, open the “Home” option and then click on the “New Group” button below the “Main tabs” window. Immediately, a “New Group(Custom)” is created inside the “Home” option.

Example 3.1

Step 4: Click on the “Rename” button below the “Main tabs” window. When the “Rename” window opens, then, in the “Display name:” field, type “My Formats”, as shown below.

Example 3.2

Step 5: On the left of the “Main Tabs”, click on the “Choose Commands from” drop-down and then select the “Commands Not in the Ribbon” option.

Example 3.3

Step 6: Once we select the “Commands Not in the Ribbon” option in the window below, scroll down to “Strikethrough” > click on the “Add” button on the right > click on “OK”. Immediately, the “Strikethrough” command is added to the “My Formats” group, as shown below.

Example 3.4

On the “Home” tab, the “My Formats” group is created, with the “Strikethrough” option, as shown below.

Example 3.5

Step 7: Finally, select cell A2, go to the “Home” tab > go to the “My Formats” group > click on the “Strikethrough” option. The output is shown below.

Example 3.6

#4 – Using It From Excel Ribbon

We will understand Strikethrough text Excel using it from the Excel ribbon options.

In the table, the data is as follows:

  • Column A contains the Emp. ID.
  • Column B contains the Emp. Name.
  • Column C contains the Annual Salary.
Example 4

The steps to Strikethrough in Excel using the Excel Ribbon are,

Step 1: Select the “File” tab > go to the “More…” options from the menu > select the “Options” as shown below.

File Options

Step 2: The “Excel Options” window opens. Now, select the “Customize Ribbon” option on the left side menu of the “Excel Options” window, as shown below.

Customize Tab2

Step 3: On the right side, click on the “New Tab” button below the “Main tabs” window. Immediately, a “New Tab(Custom)” option appears under the “Home” option.

Strikethrough in Excel Example 4.1

Step 4: Click on the “Rename” button below the “Main tabs” window, and a “Rename” window pops up. In the “Display name:” field, type “Strikethrough”, as shown below.

Strikethrough in Excel Example 4.2

Step 5: On the left of the “Main Tabs”, click on the “Choose Commands from” drop-down and then select the “Commands Not in the Ribbon” option.

Strikethrough in Excel Example 4.3

Step 6: Once we select the “Commands Not in the Ribbon” option in the window below, scroll down to “Strikethrough” > click on the “Add” button on the right > click on “OK”. Immediately, the “Strikethrough” tab is added to the ribbon, as shown below.

Strikethrough in Excel Example 4.4

On the ribbon, we will now see a “New Tab” tab with the “Strikethrough” group, as shown below.

Strikethrough in Excel Example 4.5

Step 7: Finally, select cell B2, go to the “New Tab” tab > go to the “Strikethrough” group > click on the “Strikethrough” option. The output is shown below.

Strikethrough in Excel Example 4.6

#5 – Using Dynamic Conditional Formatting

We will understand Strikethrough text Excel using the Dynamic Conditional Formatting.

In the table, the Pokémon data is as follows:

  • Column A contains the Name.
  • Column B contains the Type.
Example 5

The steps to Strikethrough in Excel using the Dynamic Conditional Formatting are,

Step 1: Select the cell range, A2:A5.

Strikethrough in Excel Example 5.1

Step 2: Select the “Home” tab > go to the “Styles” group > click on the “Conditional Formatting” drop-down > select the “New Rule…” option, as shown below.

Strikethrough in Excel Example 5.2

The “New Formatting Rule” window opens, as shown below.

Excel Example 5.3

Step 3: Select the “Use a formula to determine which cells to format” option from the “Select a Rule Type:” window.

Strikethrough in Excel Example 5.4

Step 4: In the “Edit the Rule Description:” inside the “Format values where this formula is true:” field, type the formula, =B2=“Fighter” and then click on the “Format” button.

Example 5.6

Step 5: The “Format Cells” window opens, now check/tick the “Strikethrough” option in the “Effects” window.

Example 5.5

Step 6: Finally, click on “OK”, the “Format Cells” window closes, and once again click on “OK”, the “New Formatting Rule” window closes. The output is shown below. [In Column B, when the “Type” is “Fighter”, then the respective Pokémon “Name” in Column A is crossed, according to the “Conditional Formatting”]

Strikethrough in Excel Example 5.7

#6 – Using VBA

We will understand Strikethrough text Excel using VBA.

In the table, the data is as follows:

  • Column A contains the text “Sample Text for Strikethrough”.
Strikethrough in Excel Example 6

The steps to Strikethrough in Excel using the VBA are,

Step 1: Open an Excel workbook. By default, we will see the worksheet “Sheet1”. Select cell A1 and type “Sample text for Strikethrough”.

Example 6.1

Step 2: Next, select the “Developer” tab > go to the “Code” group > click on the “Visual Basic” option, as shown below.

Developer tab (Visual Basic)

Step 3: The “Microsoft Visual Basic for Applications” window pops up on the left pane, then double-click on “Sheet1(Sheet1)”. The “Sheet1 (Code)” window opens, as shown below.

Example 6.2

Step 3: In the Sheet1 (Code)” window, type the following code,

Sub font()

Range(“A1”) = “Sample Text for Strikethrough”

Range(“A1”).font.Strikethrough = True

End Sub

Example 6.3

Step 4: To run or execute the code, select the “Run” tab from the menu > click on the “Run Sub/UserForm” option.

Strikethrough in Excel Example 6.4

The output is shown below. [The moment we execute the code, a strike appears on the text in the cell].

GIF

How To Remove Strikethrough In Excel?

We can Remove Strikethrough in Excel using the Strikethrough shortcut Excel keys, “Ctrl+5”.

In the table, the data is as follows:

  • Column A contains the text “Sample Text for Strikethrough”.
Strikethrough in Excel Example 6

The steps to Remove Strikethrough in Excel using the Strikethrough shortcut Excel keys are,

Step 1: Select cell A1 and press the shortcut keys Ctrl+5. A strike appears on the text in the cell.

Remove Strikethrough

Step 2: Select cell A1 again and press the Strikethrough shortcut Excel keys Ctrl+5. The output is shown below. [The strike disappears, and the text appears as before].

Strikethrough in Excel Example 6

Important Things To Note

  • In a cell, we can apply the Strikethrough in Excel, even to just an alphabet or a character. For example, My Name is John.
  • When we apply Strikethrough in Excel to any cell, the cell’s value does not change, and only the horizontal line appears. So, for example, “TEXT” and “TEXT” are equal.
  • We can apply Strikethrough in Excel by creating a “New Rule” using “Conditional Formatting”.

Frequently Asked Questions

What does Strikethrough mean in Excel?

The Strikethrough means striking the text, numeric value, or any other value from the center passed through the cells in Excel. For example, the text “NAME” after applying the Strikethrough in Excel is “NAME”.

How to do Strikethrough in Excel?

The different ways to apply Strikethrough in Excel are, first select the cell,

1. Click on the “Font Settings” launcher > click the checkbox of the “Strikethrough” option in the “Format cell” window.
2. Press the shortcut keys “Ctrl+5”.
3. We can create a “New Tab” or a “New Group” for Strikethrough in Excel in the Excel ribbon using the “File” tab > “Excel Options” window.
4. We can also add it in the “Quick Access Toolbar” on the “Title Bar” from the “Excel Options” window.

Where is Strikethrough in Excel?


Unlike MS Word, we do not have the Strikethrough in Excel in the Font group by default. So in Excel, we have to use the feature as follows:

1. Click the “Format Cells” launcher, shown by the yellow arrow.
2. The “Format Cells” window opens.
3. Under the “Font” menu, check/tick the “Strikethrough” checkbox in the “Effects” option.
4. Click on “OK”.

Example 2.3

Download Template

This article must help understand Strikethrough in Excel with its formulas and examples. You can download the template here to use it instantly.

This has been a guide to Strikethrough in Excel. Here we discuss top six methods to Strikethrough and how to remove it with examples and downloadable excel template. You can learn more from the following articles –

Reader Interactions

Leave a Reply

Your email address will not be published.