Strikethrough In Excel

Strikethrough in Excel is a feature that strikes the selected cell values or puts a line between cells. If the cells have some values, the value has a line mark. It is a format in Excel that we can access from the “Format Cells” tab while right-clicking on it or from the Excel keyboard shortcut “CTRL + 1” from the numeric tab of the keyboard. The process is the same for removing a Strikethrough.

For example, we will apply Excel Strikethrough to cell A1, which has the value 123.

We get the output shown above, i.e., as 123.

Below are the 6 methods to use Strikethrough in Excel.

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.

Let us discuss each method in detail with an example.

Method #1 – Strikethrough Using the Excel Shortcut Key

Method #2 – Strikethrough Using Format Cell Option

The steps to Strikethrough using Format Cell Option are as follows:

• Step 1: Select the cells that need this format, right-click on the cell, and choose the option of “Format Cells”.

• Step 2: The “Format Cells” window opens. Here, go to the “Font” tab, check/tick the “Strikethrough” option, and click “OK.”

The output is shown below, i.e., the cells got the Strikethrough format.

Method #3 – Strikethrough using from Quick Access Toolbar

Let us add the option, as it is not available in the ribbon and in the Quick Access toolbar.

The steps to Strikethrough using from Quick Access Toolbar are as follows:

• Step 1: Right-click anywhere on the ribbon, and select the Customize Quick Access Toolbar.

• Step 2: The “Excel Options” window appears.
  • On the left, select the “Quick Access Toolbar” option.
  • On the right, click the “Choose commands from:” option drop-down, and select the “Commands Not in the Ribbon” option.

• Step 3: Next, select the “Strikethrough” command, click “Add,” and click “OK.”

• Step 4: After the option is added, it will appear on the “Title Bar”, as shown.

• Step 5: Select the data you want to Strikethrough, and click the “Strikethrough” option, as shown in the screenshot below.

• It will Strikethrough the selected cells, as shown below.

Method #4 - Strikethrough using it from Excel Ribbon

The steps to Strikethrough using it from Excel Ribbon are as follows:

• Step 1: Right-click the “Font” tab, and choose the “Customize the Ribbon” option.

• Step 2: The “Excel Options” window appears.
  • On the left, select the “Quick Access Toolbar” option.
  • On the right, click the “Choose commands from:” option drop-down, and select the “Commands Not in the Ribbon” option.
  • Finally, select the “Strikethrough” option, click “New Tab,” and click “OK.”

• Step 3: After the option is added, a “New Tab” tab appears in the ribbon, with only the “Strikethrough” group, as shown below.

Step 4: Finally, select the cells you want to Strikethrough - go to the “New tab” tab - click the “Strikethrough” from the “New Group”. The output is shown below.

Method #5 – Strikethrough using Dynamic Conditional Formatting

• Step 1: Choose the range where we want to apply the conditional formatting, click the “Conditional Formatting” option drop-down in the “Home” tab’s “Styles” group, and then click the “New Rule”, as shown below.

• Step 2: Click on “Use a formula to determine which cells to format”, insert the formula as (=B2=” Yes”), and then click “Format.”

Step 3: The “Format Cells” window appears. Here, go to the “Font” tab, check/tick the “Strikethrough” option, and click “OK.”

Step 4: After the Conditional Formatting, Excel will automatically strike out the text, as shown below.

Method #6 – Strikethrough Using VBA

We will create a Strikethrough command button using VBA.

The steps to Strikethrough using VBA are as follows:

• Step 1 – Choose the “Command button” from the “Insert” command available in the “Controls” group under the Developer tab excel.

• Step 2 – Create the command button, and change the “Properties”, as shown in the images below.

• 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.)

• Step 4 – Choose “Strikethrough” from the list.

Now, paste the following VBA code.

• 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).

Select the cells, and click the button, to get the following output.

• Strikethrough, when applied, does not change the value of the cell. For example, “TEXT” is the same as “TEXT” for Excel and formulas.
• If we only want a certain part of the cell value to Strikethrough, we must select that part instead of the complete cell.
• If we are using Conditional Formatting for Strikethrough, we should keep in mind that the reference of the range must not be an absolute or a relative range reference.
• While adding the shortcut of the strike, we should keep in mind that we cannot edit the tabs that Excel creates. We cannot add this option to the “Font” tab, as this is a default tab that we cannot edit in any way.