How to Strikethrough in Excel

How to Strikethrough in excel and Count Strikethrough Cells

What is it:

Strikethrough is a Font Effect in Excel Format Cells options. In this tutorial you will learn how to strikethrough a word/vale in Excel cell. Below is an example of how strike through looks like in excel [highlighted in red font].

strikethrough in excel

You can draw a strikethrough line on a complete word or only on a selected character in a cell.

In the above example row 8 & 9 are completely stroked off and in row 2 only few characters in the cell are stroked off. You have to select entire row/cell/character as required to apply the Strikethrough Effect.

Now let’s see how this has been done in different Excel versions [Excel 2003, Excel 2007, Excel 2010, Excel 2011 for Mac, Excel 2013 and Excel 2016]. Along with shortcut key to strike out text in excel.

As mentioned earlier Strikethrough is a Font Effect in Excel Format Cells options hence you can use the shortcut key Ctrl+Shift+F to launch the Format Cells: Font option in Excel.

strikethrough in excel shortcut key

How to strikethrough in excel 2003

 

Step 1: Select the row/cell/Text

Step 2: Right click and launch the Format Cells: Font

strikethrough_in_excel_2003

Step 3: Tick mark the Strikethrough effects and click OKstrikethrough_in_excel_2003

You can see the Strikethrough line over the text now

strikethrough_in_excel_2003

How to strikethrough in excel 2007

 

Step 1: Select the row/cell/Text

Step 2: Right click and launch the Format Cells: Font

strikethrough_in_excel_2007

Step 3: Tick mark the Strikethrough effects and click OK

strikethrough_in_excel_2007

You can see the Strikethrough line over the text now

strikethrough_in_excel_2007

How to strikethrough in excel 2010





Step 1: Select the row/cell/Text

Step 2: Right click and launch the Format Cells: Font

strikethrough_in_excel_2010

Step 3: Tick mark the Strikethrough effects and click OK

strikethrough_in_excel_2010

You can see the Strikethrough line over the text now

strikethrough_in_excel_2010

How to strikethrough in excel 2011 for Mac

 

Step 1: Select the row/cell/Text

Step 2: Right click and launch the Format Cells: Font

strikethrough_in_excel_2011_Mac

Step 3: Tick mark the Strikethrough effects and click OK

strikethrough_in_excel_2011_Mac_02

You can see the Strikethrough line over the text now

strikethrough_in_excel_2011_Mac_03

How to strikethrough in excel 2013

 

Step 1: Select the row/cell/Text

Step 2: Right click and launch the Format Cells: Font

strikethrough_in_excel_2013_01

Step 3: Tick mark the Strikethrough effects and click OK

strikethrough_in_excel_2013_02

You can see the Strikethrough line over the text now

strikethrough_in_excel_2013_03

How to strikethrough in excel 2016

 

Step 1: Select the row/cell/Text

Step 2: Right click and launch the Format Cells: Font

strikethrough_in_excel_2016_02

Step 3: Tick mark the Strikethrough effects and click OK

strikethrough_in_excel_2016_03

You can see the Strikethrough line over the text now

strikethrough_in_excel_2016_04

Now that you know how to do strikethrough in excel, the next question would be how to count strikethrough cells.

In our above example since there are only 6 cells with strikethrough value its easy to count manually.  If the excel sheet has lots of rows and columns with many strikethrough cells and you want to know the exact count then you need a shortcut.

Use the below excel function to count strikethrough cells in excel.

=CountSrtikeCells()

There is no default excel function to count strikethrough cells in excel hence for the above function to work you need to input the a VBA Code.

You can refer the VBA Beginners Guide here.

Step 1. Open the excel workbook and press Alt+F11.

Step 2. Click Insert Module (Step 1 of this example) and Copy & Paste the below VBA code.

Public Function CountStrikeCells(pWorkRng As Range) As Long
Application.Volatile
Dim pRng As Range
Dim xOut As Long
xOut = 0
For Each pRng In pWorkRng
If pRng.Font.Strikethrough Then
xOut = xOut + 1
End If
Next
CountStrikeCells = xOut
End Function

vba code to count strikethrough cells

Step 3. Enter the CountSrtikeCells function in any blank cell and you will get the count of cells with strikethrough.

excel formula to count strikethrough cells

Feel Free to ask if you need to know anything more about strikethrough in excel.

About Anson

I’m Anson, having versatile experience in Business Process Outsourcing, Finance & Accounting, Information Technology, Operational Excellence & Business Intelligence. I'm currently working in a MNC in Bangalore, India. Learning anything new has always been my passions and if its related to Business and Technology then, I love it. This website/blog is an outcome of my passion towards it and I have been blogging since 2012. Outside business and technology I’m a movie freak who spends hours together watching and learning Cinema.

One Comment

  1. Great post you have covered versions as well best part is how well you explain

Leave a Reply