How to Filter by Strikethrough in Excel (Step by Step)

Formulas & functions · Updated November 20, 2026

Excel does not have a built-in filter that detects strikethrough formatting. The most reliable workaround is to create a helper column that labels cells with strikethrough, then filter that column for Yes. In desktop Excel for Microsoft 365 on Windows, you can fill the helper column with a short VBA macro; if macros are unavailable, use Find by Format and mark the matching rows manually.

This method is useful for separating completed, cancelled, or otherwise crossed-out entries without changing the data itself. It works on formatting applied to an entire cell. If only some characters inside a cell are struck through, check the limitation in Troubleshooting before relying on the results.

What You’ll Need

  • Desktop Excel for Microsoft 365 on Windows to run the macro. Excel for Mac can also run VBA, although the editor and shortcuts may differ.
  • A workbook with a header row and a column whose cells you want to inspect. The macro checks one column at a time.
  • An empty column immediately to the right of the selected data column, or permission to replace its contents. The macro writes its results there.
  • A saved backup. If you need to keep the macro in the workbook, save a copy as an Excel Macro-Enabled Workbook (.xlsm).

Excel for the web cannot run VBA. You can still filter helper-column results already created in desktop Excel, or use the manual Find by Format approach below.

Step-by-Step

  1. Save a copy and check the layout. Save the workbook before changing it. Make sure the data has a header in the first row of its table and that the column you want to inspect is next to a blank column. The code writes a heading one row above the selected cells, so select data rows only—not the header. For example, if the header is in A1 and the entries are in A2:A50, select A2:A50. If the adjacent helper column has data, move it or choose a different place for the helper before continuing.
  2. Open the VBA editor. In Excel for Windows, press Alt+F11. If the Developer tab is visible, you can also choose Developer > Visual Basic. In the editor, choose Insert > Module to add a standard module. On a Mac, use Developer > Visual Basic if available, or look under Tools > Macro for the Visual Basic Editor; keyboard shortcuts can vary by keyboard and Excel settings. Excel for the web does not include this editor.
  3. Paste the macro into the module. Before running any macro, keep a backup of the workbook: VBA actions cannot be reversed with Ctrl+Z. Paste the code below into the new module. It checks each selected cell and writes Yes, No, or Mixed beside it. Mixed means Excel reports inconsistent strikethrough formatting for that cell.
  4. Run it on the target column. Return to the worksheet, select the data cells in the one column to inspect, and press Alt+F8 on Windows. Choose MarkStrikethrough and click Run. If the output column or its heading cell already contains something, the macro asks before clearing those contents. Choose No if you do not want them replaced. The macro does not delete rows or change the source values.
  5. Filter the helper results. Include the helper heading and results in the same filter range as the original headers and records. Select the full data range, including the new helper column, then choose Data > Filter. If the filter arrows already exist, use the arrow on the helper heading instead. Clear Select All and select Yes to show only rows whose inspected cell is struck through. Select No to show the other uniformly formatted cells; Mixed is a separate result.
  6. Review and keep the result. Confirm a few visible rows by checking their formatting. If the data is an Excel table, make sure the helper is part of the table; if it is not, add or resize the table so the helper heading gets a filter arrow. Save the workbook. If you do not need to keep the macro, you can retain the helper results and save a separate copy as .xlsx; that format does not preserve VBA code.

Here is the macro. It requires one selected column of data below row 1, and it writes the helper results immediately to the right. It does not handle partial strikethrough within a cell as a separate character-level test.

Sub MarkStrikethrough()
    ' Mark whole-cell strikethrough formatting in the next column.
    Dim sourceRange As Range
    Dim outputRange As Range
    Dim headerCell As Range
    Dim cell As Range
    Dim i As Long
    Dim answer As VbMsgBoxResult

    If TypeName(Selection) <> "Range" Then Exit Sub
    Set sourceRange = Selection

    If sourceRange.Areas.Count <> 1 Or sourceRange.Columns.Count <> 1 Then
        MsgBox "Select one continuous column of data cells."
        Exit Sub
    End If

    If sourceRange.Row = 1 Then
        MsgBox "Select data below the header row."
        Exit Sub
    End If

    If sourceRange.Column = sourceRange.Worksheet.Columns.Count Then
        MsgBox "There is no column available to the right."
        Exit Sub
    End If

    Set outputRange = sourceRange.Offset(0, 1)
    Set headerCell = sourceRange.Cells(1, 1).Offset(-1, 1)

    If Application.WorksheetFunction.CountA(outputRange) > 0 Or _
       Len(headerCell.Value) > 0 Then
        answer = MsgBox("Replace contents in the helper column?", _
                        vbYesNo + vbExclamation, "Confirm overwrite")
        If answer <> vbYes Then Exit Sub
        outputRange.ClearContents
        headerCell.ClearContents
    End If

    headerCell.Value = "Strikethrough?"
    For i = 1 To sourceRange.Rows.Count
        Set cell = sourceRange.Cells(i, 1)
        If IsNull(cell.Font.Strikethrough) Then
            outputRange.Cells(i, 1).Value = "Mixed"
        ElseIf cell.Font.Strikethrough = True Then
            outputRange.Cells(i, 1).Value = "Yes"
        Else
            outputRange.Cells(i, 1).Value = "No"
        End If
    Next i
End Sub

To use a manual method instead, choose Home > Find & Select > Find, then expand Options. Choose Format, use Choose Format From Cell to sample a struck-through cell, or set the format through the Font tab and select Strikethrough. Choose Find All to see matching cells. Finding cells this way does not create a filter: use the results to mark a helper column, then filter that column. Inspect the matches first, because a format search can depend on other font settings in the sampled cell.

Common Mistakes

  • Selecting the header along with the data. The macro expects only data cells and puts its own heading directly above the helper results. Selecting a header can cause the helper heading to land on the wrong row.
  • Filtering only the original columns. The helper column must be inside the filtered range or table. If it sits outside, Excel will not provide the needed helper filter arrow.
  • Assuming a visual mark is a data value. Strikethrough is formatting, not text that Excel’s ordinary text filters can search for. A filter for words such as “done” will not detect the font effect.
  • Overwriting useful adjacent data. The macro writes to the next column and may clear its contents after you confirm. Check that column before running it, and cancel if it contains information you need.
  • Expecting the helper result to update automatically. The macro writes fixed Yes/No/Mixed values. If you change strikethrough formatting later, run it again to refresh the helper results.

Tips

  • Use a clear helper heading such as Strikethrough? so other people understand what the filter represents.
  • For a small list, manually enter Yes or No in a helper column after checking each row. This avoids enabling macros and is often quicker than setting up VBA.
  • Keep the helper column until you have finished reviewing or exporting the filtered records. Removing it also removes the convenient way to repeat the filter.
  • If you use a table, add the helper as a table column so its filter arrow and row behavior stay aligned with the records.
  • If you are working in Excel for Mac, the filter workflow is the same once the helper values exist. The VBA editor access and function-key combinations may differ from Windows.
  • For shared workbooks, tell collaborators that the helper is a snapshot of the formatting when the macro ran. Rerun the macro after any formatting changes.

Troubleshooting

The macro is missing from the Run list. Confirm you pasted it into a standard module, not a worksheet code window, and that the workbook is open in desktop Excel. If you want the macro saved with the file, use .xlsm. Follow your organization’s macro security rules and enable macros only for files you trust.

Excel says the selection is invalid. Select a single, continuous range in one column, below its header. Do not select multiple columns, separate blocks, or the whole worksheet. Also check that the selected column is not the last worksheet column, since the macro needs space to write next to it.

There is no filter arrow on the helper heading. The helper may be outside the current filter range. Turn off the filter, select the complete range from the original header through the helper column, and choose Data > Filter again. For a table, resize it or add the helper column to the table.

Rows you expected are labeled No or Mixed. Click one source cell and inspect Home > Font to confirm strikethrough is applied. If the cell contains partial character formatting, Excel may report mixed formatting rather than a single cell-level True or False. The macro labels that case Mixed; review those cells manually or standardize the formatting across the entire cell before running the macro again.

The filter results look out of date. Run the macro again on the same source range after changing formatting. If rows are hidden by another filter, the macro still checks the selected range, including hidden rows. Clear other filters if you are unsure which records you are viewing.

You are using Excel for the web. VBA cannot run there. Open the workbook in desktop Excel to create the helper values, or use Find by Format and mark matches manually. Once the helper column exists, ordinary column filtering is available in the web app.

Frequently Asked Questions

Can Excel filter strikethrough directly?
No. Excel’s standard filter menu can filter values and certain formatting such as cell color, but it does not offer a direct strikethrough criterion. A helper column is the practical workaround.

Can I filter by strikethrough without VBA?
Yes, for a small dataset you can inspect rows and enter Yes or No in a helper column yourself. Find by Format can help locate matching cells, but it does not turn them into a filter criterion on its own.

Does this macro remove strikethrough formatting?
No. It reads the selected cells’ formatting and writes labels beside them. It does not change the source values or font formatting. It can replace contents in the adjacent helper area only after you approve the prompt.

Will the helper update when I strike through a cell?
No. The Yes, No, and Mixed labels are values written when the macro runs, not live formulas. Rerun the macro after changing formatting to refresh them.

Can I filter partial strikethrough in a cell?
Not reliably with this cell-level macro. If only some characters are struck through, the cell can have mixed character formatting. Review those entries manually or make the formatting uniform before filtering.

Can I do this in Excel for Mac?
Excel for Mac desktop supports VBA, though the route to its editor and keyboard shortcuts can differ. Excel for the web does not run VBA, but it can filter helper-column labels created in desktop Excel.

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.