How to Strikethrough in Excel

In this Excel tutorial, you will learn how to strikethrough in Excel.

There is one problem with strikethrough in Excel. There is no direct strikethrough icon in Excel ribbon. That’s why it is not so obvious to strikethrough in your spreadsheet. Luckily, it is not difficult to strike through either. There are a few methods to strikethrough which you will find in this tutorial.

Keyboard shortcut of strikethrough

The easiest way to add a strikethrough is to use the Excel keyboard shortcut CTRL + 5. Simply select the cell and press CTRL + 5.

strikethrough keyboard shortcut

The text will be crossed out immediately.

Strikethrough format cells

The other way is to strikethrough by format cells. To open format cells window just use another keyboard shortcut CTRL + SHIFT + F. In the new window it will be a strikethrough check box in the Effects section. Just tick the check box and do add strikethrough to your spreadsheet.

format cells

This method allows you to access additional formatting options for text and values, such as changing the font size, color, or style. It can be particularly useful if you need to apply multiple formatting options at once or if you want to modify the formatting of a large selection of cells.

Strikethrough conditional formatting

There is not a problem to introduce strikethrough by conditional formatting. For example to cross out cells which met given condition.

strikethrough data table for conditional formatting

In the example the condition is met when the target sales are reached (=B2>C2 formula).

See also  How to open QIF file in Excel?

To add conditional formatting just go to Ribbon and click Conditional Formatting – New Rule and choose Use a formula to determine which cells to format option.

As a Format values where this formula is true I chose =$D2=TRUE to enable conditional formatting only for cells which reached the target sales.

edit conditional formatting

After clicking Format… button it will open Format Cells window which you already know.

format cells

The conditional formatting crossed out the cities in column A.

strikethrough data table

Add strikethrough to the Quick Access Toolbar

If you don’t like CTRL + 5 keyboard shortcut and strikethrough a lot you may want to add strikethrough icon to the Quick Access Toolbar. To do that just right click Quick Access Toolbar and choose Customize Quick Access Toolbar option.

Customize Quick Access Toolbar

In the next window choose All Commands and scroll down to S. After checking the Strikethrough click Add.

strikethrough quick access toolbar

You can see strikethrough icon added to the Quick Access Toolbar.

strikethrough icon quick access toolbar

Add strikethrough to the Ribbon

There is also a possibility to add strikethrough button to the Ribbon. Right click somewhere on the ribbon and choose Customize the Ribbon option. Similarly choose strikethrough, then add your New Group in the Ribbon and click Add button.

strikethrough ribbon

You can see strikethrough button (and new group) added to the Ribbon.

strikethrough button ribbon

Strikethrough VBA macro

I prepared the two marcos:

strikethrough vba macros

to add strikethrough:

Sub Strikethrough()

  Selection.Font.Strikethrough = True

End Sub

to remove strikethrough :

Sub NoStrikethrough()

  Selection.Font.Strikethrough = False

End Sub

Just run the macro to add or remove strikethrough in the cell.

Using tilde

Indubitably, an alternative approach to apply strikethrough in Excel is as follows:

See also  How to remove green triangles from cells

Firstly, highlight the cell(s) that encompass the text or values that are to be strikethrough. Then, navigate to the formula bar, located at the apex of the Excel window, and append two tilde characters (~) preceding and following the desired text or values to indicate the implementation of the strikethrough effect. For instance, if the intention is to strikethrough the text “Hello,” one must type Hello in the formula bar. Afterward, press the Enter key to validate the formula. Upon doing so, the chosen text or values shall manifest a strikethrough line, indicating the successful application of the aforementioned formatting.

This method is distinctive from its precursors as it employs a formula to execute the strikethrough formatting, allowing for the amalgamation of larger calculations and the inclusion of pre-existing formulas. Nevertheless, it is crucial to note that the tilde characters will remain visible in the formula bar even after the application of the formatting.