Strikethrough Text in Excel

Excel Strikethrough Text

Strikethrough text in excel means a line going between the texts in an excel cell, to this we can use the format option of any cell by right-clicking on it and enable the option or checkbox for strikethrough which will draw a line to the text, there is also a keyboard shortcut to do it which is CTRL+5.

Strikethrough Text in Excel

You are free to use this image on your website, templates etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: Strikethrough Text in Excel (wallstreetmojo.com)

6 Different Methods to Strikethrough Text in Excel

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

Now let us discuss each of the methods with an example –

You can download this Strikethrough Text Excel Template here – Strikethrough Text Excel Template

Method #1 – Strikethrough Text Using the Shortcut Key

Strikethrough text shortcurt key

Now suppose we have a project. The steps for the project are given in the below image.

Strikethrough text Example 1

As we will complete each step, we want to Strikethrough the step. For this, the steps are so simple.

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


    Strikethrough text Example 1-1

    In our example, we don’t have a requirement to highlight only some part of the value in the cell. Otherwise, first, we need to go into edit mode for the particular cell by double-clicking on the cell or using the F2 key and then select the text and then pressing Ctrl+5.

  2. Press F2 to enter into edit mode or double click on the cell.


    Strikethrough text Example 1-2

  3. Press Ctrl+5 to strikethrough the text.


    Strikethrough text Example 1-3

  4. Press Enter 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 text Example 2

Steps are:

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

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

Strikethrough text Example 2-4

Method #3 – By adding the Strikethrough button to Quick Access Toolbar

To add the Strikethrough button to the Quick Access toolbarQuick Access ToolbarQuick Access Toolbar (QAT) is a toolbar in Excel that may be customized and is located on the upper left-hand side of the window. It enables users to save important shortcuts and easily access them when needed.read more is one time set up, and then we can use the button from QAT (Quick Access Toolbar) whenever required.

To add the button to the QAT, steps are:

  • Step 1 – Right-click anywhere 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 on the ‘Add’ button to add the command button to the Quick Access Toolbar.
Example 3-2
  • Step 4 – The up and down arrow buttons on the right side can be used to change the position of the Strikethrough button. We have changed the position of the ‘Strikethrough’ button to the 4th on the QAT. Click on OK.
Example 3-3
  • Step 5 – We can find out the ‘Strikethrough’ command at 4th place on the QAT. As the command is at the 4th position, we can also 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

Strikethrough command is not available on the MS Excel ribbonExcel RibbonThe ribbon is an element of the UI (User Interface) which is seen as a strip that consists of buttons or tabs; it is available at the top of the excel sheet. This option was first introduced in the Microsoft Excel 2007.read more by default. We can find out the same only in the “Format Cells” dialog box. However, we can add the same command on the ribbon too. To do the same, the steps are:

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” To create the new group, steps are:
    1. Select the tab under which you want to create the group. (In our case, the tab is the “Home” tab.)
    2. Click on “New Group.”
    3. Rename the group using “Rename.”
Example 4-2
  • Step 4 – Now add the “Strikethrough” command in the New group (My Format).
Example 4-3
  • Step 5 – We can change the position of the group using the up and down arrow button on the right side of the dialog box then click ‘OK.’
Example 4-4
  • Now we can see a new group, “My Format,” under the Home tab.
Strikethrough text Example 4-5
  • Suppose we need to format some of the Text with Strikethrough.
Example 4-6

To Strikethrough the values, steps are:

  • Select the cells which 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 which we need to accomplish. We can update the status for the task as “Done,” the task value will be formatted with Strikethrough, and the font color will be changed to blue automatically.

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” from that choose “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 on 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 VBAUsing VBAVBA code refers to a set of instructions written by the user in the Visual Basic Applications programming language on a Visual Basic Editor (VBE) to perform a specific task.read more.

Steps 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.
Strikethrough text Example 6-1
Example 6-2
  • Step 3 – Click on “View Code” from the “Controls” group after closing the properties dialog box. (Make sure the button is selected and “Design Mode” is activated.)
Example 6-3
  • Step 4 – Choose “Strikethrough” from the list and paste the following code.
Strikethrough text Example 6-4
Strikethrough text Example 6-5
  • Step 5 – Save the file with .xlsm

Now 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 on the button.

Strikethrough text Example 6-7

Recommended Articles

This has been a guide to Strikethrough Text in Excel. Here we discuss how to Strikethrough Text in Excel using 6 different ways along with shortcuts, examples, and downloadable excel template. You may learn more about excel from the following articles –

  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>