Strikethrough In Excel

Article byBabita Sehdev
Edited bySheeba M
Reviewed byDheeraj Vaidya, CFA, FRM

What Is 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.

Strikethrough in Excel Intro

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

Key Takeaways

  • The Strikethrough in Excel helps users to strike any selected cell value, as a whole or a part of it, without changing the cell values, in the various methods.
  • We can add a Strikethrough in simple ways, such as using the shortcut keys, i.e., “Ctrl+5”, adding the feature by creating a New tab, or in the Quick Access Toolbar, using Conditional Formatting, the Format Painter option, and a little more advanced way using the VBA Code.
  •  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.

Top 6 Methods To Use Strikethrough In Excel

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 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.
  5. Using Dynamic Conditional Formatting.
  6. Using VBA.

Let us discuss each method in detail with an example.

–>> If you want to learn Excel and VBA professionally, then ​Excel VBA All in One Courses Bundle​ (35+ hours) is the perfect solution. Whether you’re a beginner or an experienced user, this bundle covers it all – from Basic Excel to Advanced Excel, Macros, Power Query, and VBA.

Method #1 – Strikethrough Using the Excel Shortcut Key

The steps for Strikethrough using the Excel shortcut key are as follows:

  1. First, select the cells in which we need the Strikethrough format.


    Strikethrough Method 1

  2. Now, use the Excel Strikethrough shortcut key, “Ctrl+5”. The data will strike out, as shown below.


    Strikethrough Method 1-1

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”.
Strikethrough Shortcut Excel Method 1-2
  • Step 2: The “Format Cells” window opens. Here, go to the “Font” tab, check/tick the “Strikethrough” option, and click “OK.”
Strikethrough Shortcut Excel Method 1-3

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

Strikethrough Shortcut Excel Method 1-4

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 toolbarRibbon And In The Quick Access ToolbarRibbons in Excel 2016 are designed to help you easily locate the command you want to use. Ribbons are organized into logical groups called Tabs, each of which has its own set of functions.read more.

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

Strikethrough Method 2
  • 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.
Strikethrough Method 2-1
  • Step 3: Next, select the “Strikethrough” command, click “Add,” and click “OK.”
Strikethrough Method 2-2
  • Step 4: After the option is added, it will appear on the “Title Bar”, as shown.
Strikethrough Method 2-3
  • Step 5: Select the data you want to Strikethrough, and click the “Strikethrough” option, as shown in the screenshot below.
Strikethrough Shortcut Excel Method 2-4
  • It will Strikethrough the selected cells, as shown below.
Strikethrough Shortcut Excel Method 2-4

Method #4 – Strikethrough using it from Excel Ribbon

The steps to Strikethrough using it from 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 are as follows:

  • Step 1: Right-click the “Font” tab, and choose the “Customize the Ribbon” option.
Strikethrough Method 4
  • 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.”
Strikethrough Method 4-1
  • Step 3: After the option is added, a “New Tab” tab appears in the ribbon, with only the “Strikethrough” group, as shown below.
Strikethrough Method 4-2

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.

Strikethrough Shortcut Excel Method 4-3

Method #5 – Strikethrough using Dynamic Conditional Formatting

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

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

Method 5-2

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

Strikethrough Shortcut Excel Method 5-3

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.
Method 6 - Step 1
  • Step 2 – Create the command button, and change the “Properties”, as shown in the images below.
Method 6 - Step 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.)
Method 6 - Step 3
  • Step 4 – Choose “Strikethrough” from the list.
Method 6 - Step 4

Now, paste the following VBA code.

Method 6 - Step 4- 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).

Method 6 - Step 5

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

Method 6.gif

Important Things To Note

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

Frequently Asked Questions

1. 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”.

Format Cell

2. What methods open the Format Cells window to Strikethrough in Excel?

There are various methods to open the Format Cells window, namely,
Method 1 Simply press the shortcut key “Ctrl+1”.
Method 2 Select the “Home” tab – go to the “Number” group – click the “Number Format” option drop-down – select the last option “More Number Formats…”, as shown below.

Fractions in Excel FAQ 3 - Method 2

Method 3 Right-click on any cell, and select the “Format Cells…” option from the list, as shown below.

FAQ 3 - Method 3

· Method 4 Select the “Home” tab – go to the “Number” group – click the “Number Format” box, i.e., the small box at the bottom right of the “Number” group, as shown below.

Fractions in Excel FAQ 3 - Method 4

3. Is there an Alternate way to Strikethrough in Excel?

Yes, there is an alternate way to convert decimal values to Strikethrough in Excel using the “Format Painter” option.
For example, when we have multiple cell values to Strikethrough,
First, select the cell value which has already has a Strikethrough format.
Next, select the “Home” tab – go to the “Clipboard” group – click the “Format Painter” option to copy the cell formatting, as shown below.

Home - Format Painter

Finally, paste it to the cell with another cell value without the Strikethrough formatting. Repeat the same with the other cells too.

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.

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

This article has been a guide to Strikethrough in Excel. Here we use Strikethrough using shortcut, QAT, customize ribbon, VBA, examples, downloadable excel template. You may learn more about Excel from the following articles: –