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.
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.
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.
In the example the condition is met when the target sales are 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.
After clicking Format button it will open Format Cells window.
The conditional formatting crossed out the cities in column A.
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.
In the next window choose All Commands and scroll down to S. After checking the Strikethrough click Add.
You can see strikethrough icon added to the 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.
You can see strikethrough button (and new group) added to the Ribbon.
Strikethrough VBA macro
I prepared the two marcos:
to add strikethrough:
Selection.Font.Strikethrough = True
to remove strikethrough :
Selection.Font.Strikethrough = False
Just run the macro to add or remove strikethrough in the cell.
Another alternative method is to manually apply strikethrough by using the tilde (~) character.
Highlight the text or numbers in the formula bar and enclose them with two tilde characters (~) on each side (e.g., text).
Press Enter, and the selected text or numbers will be displayed with strikethrough.