How to Filter Crossed-Out Text in Excel

Formulas & functions · Updated November 20, 2026

Excel cannot filter rows directly by strikethrough formatting. The practical method is to use a short VBA macro to mark cells with crossed-out text in a helper column, then filter that column for “Yes.” You will need the desktop Excel app for the macro; if you cannot use macros, a find-format-and-color workaround is included below.

What You’ll Need

  • Excel for Microsoft 365 on Windows, with the workbook open in the desktop app. Excel for the web cannot run VBA macros.
  • A column containing the text or values you want to check, with a header in row 1 and data starting in row 2.
  • A blank helper column to hold the “Yes” or “No” results. The macro will ask for its column letter.
  • Permission to use macros. Save a copy of your workbook first: macro changes cannot be undone with Ctrl+Z.

Step-by-Step

  1. Save a working copy and identify the column to check. Save the workbook before changing anything. Note the column containing the cells whose strikethrough formatting matters, such as column A, and make sure its heading is in row 1. The procedure below assumes the list has one header row and the data begins in row 2. Choose a different, empty column for the helper results; for example, if the text is in A, you might use D. Do not use the source column or a column containing information you need.

  2. Select the cells to inspect, not the heading. Select the data cells in the one column you want to check. For example, select A2:A500 if the text is in A and your list runs through row 500. Include all relevant rows, including rows that are not currently visible because of an existing filter. The macro examines only the selected cells, so omitted rows will not receive a result. Select one continuous range in one column; do not include the heading.

  3. Open the Visual Basic editor. In Windows, press Alt+F11, or select Developer > Visual Basic on the ribbon. If Developer is not visible, turn it on through File > Options > Customize Ribbon and check Developer. On a Mac, use Developer > Visual Basic; the exact keyboard shortcut can vary by keyboard settings. Excel for the web does not provide the VBA editor or run this macro.

  4. Insert a module and add the macro. In the Visual Basic editor, select Insert > Module, then paste the code below into the blank module. The macro checks each character in each selected cell. If at least one character has strikethrough formatting, it writes “Yes” in the corresponding helper cell; otherwise it writes “No.” It also adds a heading above those results.

    Sub MarkStrikethroughRows()
        Dim sourceRange As Range
        Dim cell As Range
        Dim ws As Worksheet
        Dim answer As Variant
        Dim outputCol As Long
        Dim textValue As String
        Dim i As Long
        Dim hasStrike As Boolean
    
        ' Check that one continuous column of data is selected.
        If TypeName(Selection) <> "Range" Then Exit Sub
        Set sourceRange = Selection
        If sourceRange.Columns.Count <> 1 Or sourceRange.Areas.Count <> 1 Then
            MsgBox "Select one continuous data range in one column."
            Exit Sub
        End If
        If sourceRange.Row < 2 Then
            MsgBox "Select data beginning in row 2 or lower, not the header."
            Exit Sub
        End If
    
        Set ws = sourceRange.Worksheet
        answer = Application.InputBox( _
            "Enter the blank helper column letter, such as D.", _
            "Helper column", Type:=2)
        If VarType(answer) = vbBoolean Then
            If answer = False Then Exit Sub
        End If
    
        On Error GoTo InvalidColumn
        outputCol = ws.Range(CStr(answer) & "1").Column
        On Error GoTo 0
        If outputCol = sourceRange.Column Then
            MsgBox "Choose a helper column different from the source column."
            Exit Sub
        End If
    
        ws.Cells(sourceRange.Row - 1, outputCol).Value = "Strikethrough"
        For Each cell In sourceRange.Cells
            hasStrike = False
            If Not IsError(cell.Value2) Then
                textValue = CStr(cell.Value2)
                For i = 1 To Len(textValue)
                    If cell.Characters(i, 1).Font.Strikethrough = True Then
                        hasStrike = True
                        Exit For
                    End If
                Next i
            End If
            If hasStrike Then
                ws.Cells(cell.Row, outputCol).Value = "Yes"
            Else
                ws.Cells(cell.Row, outputCol).Value = "No"
            End If
        Next cell
        MsgBox "Helper results are ready. Filter the helper column for Yes."
        Exit Sub
    
    InvalidColumn:
        MsgBox "Enter a valid worksheet column letter, such as D."
    End Sub

    Enter the code as shown. The “Yes” result means at least one character in the cell is struck through, not necessarily that every character is. If you only want to count cells where the entire text is crossed out, see the Tips section before filtering.

  5. Run the macro on your selected range. Return to the worksheet and confirm that the source range is still selected. In Windows, press Alt+F8, choose MarkStrikethroughRows, and select Run. On a Mac, use Tools > Macro > Macros if that menu is available, or run it from the Visual Basic editor. When prompted, enter the blank helper column letter, such as D, and confirm. The macro writes its heading one row above the selected range and fills the corresponding rows with “Yes” or “No.” Check that you entered the intended empty column before proceeding.

  6. Turn on or update filtering. If the list already has filter arrows, use the arrow on the new helper heading. If it does not, select the full dataset including its headings and the helper column, then choose Data > Filter. Make sure the selection includes all relevant data columns; otherwise Excel may treat the helper results as a separate list instead of filtering the complete rows. If your data is an Excel table, the helper heading should appear with its own filter arrow after the column is included in the table.

  7. Show only crossed-out rows. Open the helper column’s filter dropdown, clear Select All, check Yes, and select OK. Excel hides rows marked No and displays rows where the checked cell contains strikethrough text. The other columns stay aligned with their original records. To show everything again, choose Select All in that dropdown or clear the filter using Data > Clear.

No-code alternative: If you cannot run macros, Excel can find cells by formatting, but it does not turn those matches into a lasting filter condition by itself. Press Ctrl+F, select Options, then Format > Font and set Strikethrough as the format to find. Use Find All to list matching cells. You can then apply a distinctive fill color to the selected matches and filter the source column using Filter by Color. This changes cell formatting, so use a fill color that will not overwrite meaningful colors. If your Excel build does not let you select all Find All results together, or the matches are difficult to transfer, use the helper-column method instead.

Common Mistakes

  • Expecting the normal filter menu to include strikethrough. Excel’s standard AutoFilter offers options such as text values, dates, and cell colors; it does not offer a direct strikethrough-format condition. Filtering the source column by text will not detect font formatting. Use the helper results or the color workaround.

  • Selecting the header or multiple columns for the macro. The macro expects one continuous data range in a single column, beginning on row 2 or later. Select A2:A500, for example, rather than A1:B500. Selecting the header can put the output heading in the wrong place, and selecting more than one source column causes the macro to stop.

  • Choosing a helper column that already contains data. The macro writes “Strikethrough,” “Yes,” and “No” into the column you name. It can replace existing content in the rows it processes. Pick a blank column and save a copy first. Also ensure the helper column is different from the source column.

  • Filtering a range that excludes the helper column. If the filter arrows were created before the helper column, it may not be part of the filtered range. Reapply Data > Filter to a selection that includes the entire list and the helper column, or add the helper column to the Excel table.

  • Assuming formatting is permanent data. The “Yes” and “No” values are a snapshot taken when the macro runs. If you add or remove strikethrough after running it, the helper results do not update automatically. Run the macro again after selecting the relevant source range.

Tips

  • Decide what “crossed out” means for partially formatted cells. This macro marks a cell Yes if any one character is struck through. That is useful for identifying mixed text such as “old” struck through before “new.” If you want only fully crossed-out cell text, inspect the matched rows and retain only cells where the whole entry is struck through. A cell-level font check is not a reliable way to distinguish every mixed-format case.

  • Use a clear helper heading. You can rename the helper header to something descriptive, such as “Has strikethrough,” after the macro runs. Avoid changing the Yes and No values if you plan to filter by Yes. Keeping the helper column in the workbook also makes the filter logic easy for another person to understand.

  • Re-run after edits. If someone formats new cells with strikethrough, removes the formatting, or edits the source range, select the updated data cells and run the macro again. The macro overwrites the matching helper cells with fresh results. It does not automatically detect formatting changes, and formatting changes do not necessarily trigger ordinary worksheet formula recalculation.

  • Use a workbook format that preserves macros. If you want to keep the macro in the workbook for later, save it as an Excel Macro-Enabled Workbook (.xlsm). If you save as .xlsx, Excel removes the VBA project. Follow your organization’s macro-security rules; do not enable macros in a file from an untrusted source.

Troubleshooting

  • The macro is missing from Alt+F8. Confirm that the code is in a standard module created with Insert > Module, not inside a worksheet’s code window. Check that the procedure name is MarkStrikethroughRows and that the file is open in desktop Excel. Excel for the web cannot run VBA.

  • Excel blocks the macro. Check the yellow security notification or your organization’s macro policy. Only enable macros in a workbook you trust. If your workplace blocks VBA, ask your administrator for an approved approach or use the find-format-and-color workaround.

  • You see no Yes results. Confirm that the selected source range contains the formatted cells and that the strikethrough is actual font formatting, not a line shape drawn over the text. Open Format Cells with Ctrl+1 and check the Font tab’s Strikethrough option on a sample. Then rerun the macro on that range. If the text uses mixed formatting, try a cell that is entirely struck through as a quick check.

  • The filter hides every row or shows too many. Check the helper values before changing the filter: the heading should say Strikethrough, and each data row should say Yes or No. Confirm that the filter dropdown is on the helper column and that Yes is selected. If the helper is outside the filtered range, clear the filter, select the complete dataset including the helper, and choose Data > Filter again.

  • The results are stale or shifted. Rerun the macro after formatting changes, sorting, or adding rows. Select the source cells that correspond to the current rows and check that the helper column is still alongside the correct records. A sort should include the helper column so the Yes/No values move with their rows.

Frequently Asked Questions

Can I filter strikethrough text without VBA?
Not directly with Excel’s ordinary AutoFilter. The Find Format workaround can locate struck cells and let you mark them with a fill color, then filter by that color. It is less convenient and changes formatting; a helper column populated by VBA is generally more repeatable.

Does the macro delete or change the crossed-out text?
No. It reads the selected cells’ formatting and writes results in the helper column. It does not remove strikethrough from the source cells, although it will overwrite existing values in the helper column you specify.

Can I use this in Excel for the web?
The web app can display a workbook containing a macro, but it cannot run VBA. Open the file in desktop Excel for Windows or Mac to run the procedure, subject to your macro-security settings.

Will the Yes/No results update automatically?
No. They are written values, not formulas, and formatting changes do not refresh them. Run the macro again after changing strikethrough or updating the checked range.

What if only part of a cell is crossed out?
The macro marks the row Yes when any character in the selected cell has strikethrough. Review those results if you need to distinguish a fully crossed-out entry from text with only one struck-through word.

Can I filter by strikethrough on Excel for Mac?
The ordinary filter menu has the same limitation. Excel for Mac supports VBA in the desktop app, though the editor and macro menus may differ slightly from Windows. The code and helper-column approach remain the same.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.