Strikethrough Text In Excel

Last Updated :

21 Aug, 2024

Blog Author :

Edited by :

Sheeba M

Reviewed by :

Dheeraj Vaidya, CFA, FRM

Table Of Contents

arrow

What Is Excel Strikethrough Text?

Strikethrough text in Excel is a line that goes through or between the texts in an Excel cell, which means we strike the text.

We can use the Excel Strikethrough from the “Format” option of any cell by right-clicking on it and enabling the option or checkbox for Strikethrough, which will draw a line on the text, or use the keyboard shortcut, “CTRL+5”.

For example, in the following image, we have applied the Strikethrough Text feature for cells A3 and A5. Also, on the Visual Basic Macro text, on the inserted image.

Strikethrough Text in Excel
  • The Strikethrough Text in Excel is a feature that places a line in-between the selected cell value, like striking the text.
  • We can add a Strikethrough in different ways, using the VBA Code in VBA Macro, adding the feature as a group on the Excel ribbon, using Conditional formatting, and of course, the simplest way is by using the shortcut keys, i.e., “Ctrl+5”.
  •  Irrespective of the methods we use to apply Excel Strikethrough Text, we can only use the shortcut key “Ctrl+5” to remove or delete the Strikethrough.

6 Different Methods To Strikethrough Text In Excel

We will consider 6 different methods to apply the Strikethrough Text In Excel, namely:

  1. Strikethrough Text using Shortcut Key.
  2. Using the Format Options.
  3. By Adding the Strikethrough Button to Quick Access Toolbar.
  4. Adding the Strikethrough Button to the Ribbon.
  5. Using Conditional Formatting to Strikethrough automatically.
  6. Adding a Button for Strikethrough Using VBA.

Now, let us discuss each of the methods with an example.

Method #1 - Strikethrough Text Using the Shortcut Key

Strikethrough text shortcurt key

We have a project, and the steps to be carried out are given in the below image.

Strikethrough text Example 1

As we will complete each step, we want to Strikethrough the steps that mark the completed status.

The steps to apply the Strikethrough using the shortcut keys are,

  1. Select one or more cells using the “Shift” key with the “Up,” “Down,” “Left,” and “Right” arrow keys, and press the “Ctrl+5” keys.


    Strikethrough text Example 1-1

    In our example, we do not have a requirement to highlight only some part of the value in the cell. Otherwise, we need to go into “Edit Mode” for the particular cell by double-clicking on the cell or using the “F2” key, selecting the text, and pressing the “Ctrl+5” keys.

  2. Press the “F2” key to enter edit mode or double-click on the cell.


    Strikethrough text Example 1-2

  3. Press the “Ctrl+5” keys to Strikethrough the text.


    Strikethrough text Example 1-3

  4. Press the “Enter” key to get out of the edit mode.


    Strikethrough text Example 1-4

Method #2 - Using the Format Options

Suppose we have the following data for steps. We want to Strikethrough the value as we complete each step.

Strikethrough Format option Sample

The steps to apply the Strikethrough using the Format options are,

  • Step 1 -  Select one or more cells on which we want to apply the Strikethrough, here, cell A3.
Strikethrough Format option Step 1
  • Step 2 - Press the shortcut key “Ctrl + 1,” or right-click the selected cell(s), and choose “Format Cells” from the pop-up menu.
Strikethrough Format option Step 2
  • Step 3 - In the “Format Cells” dialog box, we need to go to the “Font” tab, tick off the “Strikethrough” option under “Effects”, and then click “OK” to save the changes and close the dialog box.
Example 2-3

Now, you can see the result as shown in the below image.

Strikethrough Format option Step 3

Method #3 - By Adding the Strikethrough Button to Quick Access Toolbar

Adding the “Strikethrough” button to the  Quick Access toolbar is a one-time setup, and we can use the button from QAT (Quick Access Toolbar) whenever required.

The steps to add the button to the QAT are:

  • Step 1 - Right-click on the ribbon, and choose “Customize Quick Access Toolbar” from the pop-up menu.
Strikethrough text Example 3
  • Step 2 - The “Excel Options” dialog box appears. Now, choose “Commands Not in the Ribbon” for “Choose commands from.”
Example 3-1
  • Step 3 - From the list, choose “Strikethrough”, and click the “Add” button to add the command button to the Quick Access Toolbar.
Example 3-2
  • Step 4 - We can use the up and down arrow buttons on the right side to change the position of the Strikethrough button. We have changed the position of the “Strikethrough” button to the fourth on the QAT. Click “OK.”
Example 3-3
  • Step 5 - We can find the “Strikethrough” command at fourth place on the QAT. As the command is at the fourth position, we can use Alt+4 as a shortcut excel key to apply the Strikethrough format to the selected text.
Strikethrough text Example 3-4

Method #4 - Adding the Strikethrough Button to the Ribbon

The Strikethrough command is not available on the MS Excel ribbon by default. We can find the same in the “Format Cells” dialog box. However, we can add the same command on the ribbon too. The steps to add the Strikethrough button are:

  • Step 1 - Right-click anywhere on the ribbon, and choose “Customize the Ribbon” from the pop-up menu.
Strikethrough text Example 4
  • Step 2 - Choose “Commands Not in the Ribbon” for “Choose commands from” and select “Strikethrough” from the list.
Strikethrough text Example 4-1
  • Step 3 - Before adding the “Strikethrough” command on the ribbon, first create the group using the “New Group” using the following steps,
    1. Select the tab under which you want to create the group. (In this case, the tab is the “Home” tab)
    2. Click on “New Group.
    3. Rename the group using “Rename.
Example 4-2
  • Step 4 - Add the “Strikethrough” command in the new group (My Format (Custom).”
Example 4-3
  • Step 5 - We can change the group’s position using the up and down arrow button on the right side of the dialog box, then click “OK.”
Example 4-4
  • We can see a new “My Format” group under the “Home” tab.
Strikethrough text Example 4-5
  • We will format some of the text with Strikethrough for the following data.
Example 4-6

To Strikethrough the values, the steps are:

  • Select the cells we need to format, then choose the “Strikethrough” command from the “My Format” group under the “Home” tab.
Strikethrough text Example 4-7

Method #5 - Using Conditional Formatting to Strikethrough Automatically

We can Strikethrough the Text using conditional formatting in excel.

Suppose we have a task list that we need to accomplish. Then, we can update the status for the task as “Done”. We will format the task value with a Strikethrough, and the font color will automatically change to blue.

Strikethrough text Example 5

To do the same, the steps are:

  • Step 1 - Select the cells to format.
Strikethrough text Example 5-2
  • Step 2 - Go to the “Home” tab. From the “Styles” group, choose “Conditional Formatting.” Next, select “New Rule” from the drop-down list in excel.
Example 5-1
  • Step 3 - Choose “Use a formula to determine which cells to format.”
Example 5-3
  • Step 4 - For “Format values where this formula is true”. Specify =$B3=“Done”, and set the format as below.
Strikethrough text Example 5-4
  • Step 5 - Click “OK” for both the dialog boxes, “Format Cells” and “New Formatting Rules.”
Example 5-5

Now, whenever we update the status for a task as “Done”, the value is formatted.

Strikethrough text Example 5-6

Method #6 - Adding a Button for Strikethrough Using VBA

We can also create a command button for the same using VBA.

The steps to add a Strikethrough button using VBA are:

  • Step 1 - Choose the “Command button” from the “Insert” command available in the “Controls” group under the Developer tab excel.
Strikethrough text Example 6
  • Step 2 - Create the command button, and change the “Properties”, as shown in the images below.
Strikethrough text Example 6-1
Example 6-2
  • Step 3 - Click “View Code” from the “Controls” group after closing the properties dialog box. (Ensure the button is selected and “Design Mode” is activated.)
Example 6-3
  • Step 4 - Choose “Strikethrough” from the list.
Strikethrough text Example 6-4
Strikethrough text Example 6-5
  • Step 5 - Save the file with .xlsm

Suppose we want to Strikethrough two cells (A1 and A2). We can do the same by selecting the cells and pressing the command button (make sure the “Design Mode” is deactivated).

Example 6-6

Select the cells, and click the button.

Strikethrough text Example 6-7

Important Things To Note

  • In a cell, we can apply the Strikethrough Text in Excel, even to just an alphabet or a character.

For example, My Name is John.

  • It does not alter the cell’s value. Only the horizontal line appears. For example, “TEXT” and “TEXT” are equal.
  • We can apply this featureby creating a “New Rule” using “Conditional Formatting”.

Frequently Asked Questions (FAQs)

1. Does Strikethrough Text in Excel change the cell values?

The Strikethrough means striking the text, numeric value, or any other cell value through the center of the cell value.
For example, the text “WallStreetMojo” after applying the Strikethrough feature becomes “WallStreetMojo”. Therefore, we can see the value does not change, but the look of the text changes

2. How to perform Strikethrough text in Excel?

The different ways to apply Strikethrough text in Excel are,
First, select the cell with values in a dataset,
1) Click 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.

3. Where is option Strikethrough Text in Excel?

Unlike MS Word, we do not have the Strikethrough in Excel in the Font group by default. Therefore, we use the feature as follows:
a) Click the “Format Cells” launcher, shown by the yellow arrow.
b) The “Format Cells” window opens.
c) Under the “Font” menu, check/tick the “Strikethrough” checkbox in the “Effects” option.
d) Click “OK”.

Strikethrough Text in Excel - FAQ 3

Download Template

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

Recommended Articles

This article has been a guide to Strikethrough Text in Excel. Here we see 6 ways, Format option, Button, VBA, conditional formatting, example, downloadable template. You may learn more about Excel from the following articles: -