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.
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 which you already know.
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:
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:
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.
Leave a Reply