Sanjida Ahmed
Even though strikethrough cells are readable, it is uncomfortable for many readers. In this article, you will learn how to remove strikethrough in Excel in 3 easy ways.
Download Practice Template
You can download the free practice Excel template from here.
3 Easy Ways to Remove Strikethrough in Excel
With the following dataset as our example, we will learn how to remove strikethrough in Excel in 3 different ways.
1. Keyboard Shortcut to Remove Strikethrough in Excel
To remove strikethrough from Excel with Keyboard Shortcut,
- First, select the cells with strikethrough.
- Then press Ctrl+5 on your keyboard.
That’s it. Simply pressing Ctrl+5 on your keyboard will remove all the strikethrough from your cells.
2. Format Cells Feature to Delete Strikethrough in Excel
We can use Excel’s Format Cells feature to delete strikethrough from cells.
Steps:
- First, select the cells with strikethrough.
- Next, in the Home tab, select the Format Cells option (shown in the picture below).
- From the Format Cells pop-up window, go to the Font tab and uncheck the checkbox next to Strikethrough under the Effects option.
- Press OK.
This process will remove all the strikethrough from your cells.
3. VBA to Remove Strikethrough Rows from Excel
If you want to delete all the strikethrough rows from your Excel then VBA is the most efficient and safest method to achieve the task.
The steps to delete strikethrough rows from Excel are given below.
Steps:
- Press Alt + F11 on your keyboard or go to the tab Developer -> Visual Basic to open Visual Basic Editor.
- In the pop-up code window, from the menu bar, click Insert -> Module.
- In the code window, copy the following code and paste it.
Sub DeleteStrRows()
    Dim r As Range
    Dim iCheck As Boolean
    Dim i As Integer
    Dim iRows As Integer
    iRows = Selection.Rows.Count
    If iRows > 2 Then
        For i = iRows To 1 Step -1
            iCheck = False
            For Each r In Selection.Rows(i).Cells
                iCheck = IsNull(r.Font.Strikethrough)
                If Not iCheck Then iCheck = r.Font.Strikethrough
                If iCheck Then Exit For
            Next r
            If iCheck Then Selection.Rows(i).EntireRow.Delete
        Next i
    End If
End SubYour code is now ready to run.
- Go back to the worksheet of interest where your strikethrough rows are, select the rows and Run the macro.
This will delete all the strikethrough rows from your Excel worksheet.
Conclusion
This article showed you how to remove strikethrough in Excel in 3 different and easy ways. I hope this article has been very beneficial to you. Feel free to ask any questions regarding the topic.
