How To Strikethrough

In this Excel tutorial you will teach yourself 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 strikethrough either. There are a few methods to strikethrough which you will find in this tutorial.

Strikethrough Keyboard Shortcut

The easiest way to add strikethrough is to use Excel keyboard shortcut CTRL + 5. Just click the cell and press CTRL + 5.

strikethrough keyboard shortcut

The text will cross 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

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 is being reached (=B2>C2 formula).

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.


You can download the Template here – Download
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell