Filter Out Strikethrough Text in Excel: A Practical Guide

Formulas & functions · Updated November 20, 2026

Excel for Microsoft 365 does not have a built-in filter condition for strikethrough formatting. To filter those rows, add a helper column that identifies struck-through cells—manually, with a short VBA macro, or by using Find to locate matching formatting—then filter the helper column.

Why Excel cannot filter directly by strikethrough

Excel’s ordinary column filter works with cell values: text, numbers, dates, and blanks. Its Filter by Color option can filter by cell fill color, font color, or conditional-formatting color in supported situations, but it does not offer a setting for font effects such as strikethrough, bold, or italic. A crossed-out value may look like a distinct category to a person, but Excel still sees its underlying value as the same text or number as before.

That distinction matters when choosing a workaround. Strikethrough is formatting, not a separate data value. It does not mean a row is deleted, excluded from calculations, or automatically hidden. For example, if a task name in A2 is crossed out, the text remains in A2 and can still appear in search results, formulas, and exports. A filter needs a value it can evaluate, so the practical approach is to turn the formatting state into a label such as Struck or Active.

Quickest built-in method: mark rows manually

If you only need to filter a small list once, a helper column is usually simpler than a macro. Add a column called Status, enter a consistent label beside each row whose target cell is struck through, and then filter that column. This method is explicit and easy for other people to understand, and it works in desktop Excel and Excel for the web.

  1. Insert a blank column beside the data and give it a clear heading, such as Strike status.
  2. For each row, enter Struck if the chosen cell is crossed out. Use a different consistent value, such as Active, for rows that are not.
  3. Select the data, including the headings, and choose Data > Filter. You can also use Home > Sort & Filter > Filter.
  4. Open the helper column’s filter menu and select only Struck to show those rows. Select Active instead to exclude them.

Use one rule consistently: decide whether you are checking a particular column (for instance, the task-name cell) or whether any strikethrough anywhere in the row counts. Manual marking is dependable when the list is short, but it can become out of date if someone later changes the formatting without updating the helper value.

Automate a helper column with VBA

For a larger list that you need to classify in one pass, a VBA macro can read the formatting of a selected column and write a status beside each selected cell. The example below assumes you select only the data cells in one column, not the heading, and that the cells immediately to the right are empty. It writes Struck for fully struck-through cells, Mixed when Excel reports mixed strikethrough formatting, and clears the helper cell for other cells.

On Windows desktop Excel, save a copy of the workbook first, press Alt+F11, choose Insert > Module, paste the code into the module, and run MarkStrikethrough with the source cells selected. Add a heading such as Strike status above the results, then filter that column. Macros cannot be undone with Ctrl+Z, and this code overwrites the cells immediately to the right of the selection, so verify that those cells are clear before running it.

Sub MarkStrikethrough()
    Dim sourceRange As Range
    Dim cell As Range
    Dim statusCell As Range
    Dim strikeState As Variant

    ' Use one selected source column; write results one column to its right.
    If TypeName(Selection) <> "Range" Then Exit Sub
    Set sourceRange = Selection

    If sourceRange.Columns.Count <> 1 Then
        MsgBox "Select data cells in one column only."
        Exit Sub
    End If

    For Each cell In sourceRange.Cells
        strikeState = cell.Font.Strikethrough
        Set statusCell = cell.Offset(0, 1)

        If IsNull(strikeState) Then
            statusCell.Value = "Mixed"
        ElseIf strikeState = True Then
            statusCell.Value = "Struck"
        Else
            statusCell.ClearContents
        End If
    Next cell
End Sub

To use the macro, select the cells whose formatting you want to inspect, such as C2:C200; the macro writes results to D2:D200. Include the new status column in the filtered range. The code checks the selected cells themselves, not every cell across each row. If your rule is “mark a row when any cell in the row is struck through,” the macro needs to be adapted to examine all relevant columns.

This is a snapshot, not a live formula: changing strikethrough later does not automatically update the helper value. Run the macro again after formatting changes, or use manual statuses that you maintain as part of the workflow. VBA runs in desktop Excel, not Excel for the web; the web app can display a workbook but cannot run this macro.

Find cells with strikethrough formatting

For a one-time check, Excel’s Find dialog can search for formatting rather than a particular word. In Windows Excel, choose Home > Find & Select > Find, then select Options if the extra search settings are hidden. Open Format, go to the Font tab, select Strikethrough, and confirm the dialogs. Use Find All to see cells matching the format.

Before searching, clear any old format criteria in the Find dialog if a previous search may have left them in place. Otherwise, the search might require extra formatting characteristics as well as strikethrough and miss cells you expected to find. Find All is useful for locating matches, but it is not a persistent filter: it does not create a status field or automatically hide unmatched rows. Use the results to review the cells, then mark a helper column if you need filterable results.

The Find dialog’s arrangement can differ slightly between Windows and Mac editions, but the key is to search by formatting and specify the strikethrough font effect. Finding a match also does not change the cell’s content or remove its formatting.

Filter the helper column and keep it accurate

Once the helper column contains status values, Excel’s regular filter controls do the hiding and showing. If the range is an Excel table, put the helper heading and values inside the table so its filter menu includes the new field. If it is a normal range, make sure the filter range includes both the original data and the helper column; otherwise, filtering one column may separate records from their status labels.

For example, suppose a task list has task names in column A, owners in B, and dates in C. If you decide that strikethrough in column A means a task is completed, place the status in D and filter D for Struck. If instead you mean a row should count when any of A, B, or C has strikethrough, checking only A will produce a different result. Documenting the rule in the heading or a note prevents confusion when the workbook is shared.

  • Keep the helper heading descriptive, such as Task name struck through, rather than using an ambiguous label like Flag.
  • After adding rows, extend the filtered range or add the rows to the table so they are included.
  • If you rerun the macro, select the complete relevant data range, including newly added records.
  • Clear the filter when you want to see all records again; filtering hides rows temporarily rather than deleting them.

Common problems and misconceptions

A frequent mistake is expecting Filter by Color to recognize strikethrough. That menu is not a general-purpose formatting filter, and a font effect is not the same as font color. Another common issue is using visual appearance as the only record of a status. If a coworker removes the line through text, a manually maintained helper label or an old macro result may no longer agree with the formatting.

Strikethrough also does not reliably mean “completed” unless the workbook’s users have agreed that it does. It might mean cancelled, superseded, reviewed, or simply “do not use.” Before building a filter around it, decide what the formatting represents. If the meaning is important for reporting, store it as data in a dedicated Status column and use strikethrough only as a visual cue. That design is easier to sort, filter, summarize, and export.

Finally, a cell can contain text with only some characters crossed out. The macro above flags mixed formatting as Mixed rather than treating the entire cell as struck through. If you use partial-text formatting, decide how those cells should be classified and review the mixed cases instead of assuming the whole cell has one uniform style.

Excel for Mac and Excel for the web

The helper-column method works across Excel platforms because it relies on ordinary cell values and filters. Excel for the web does not run VBA, so use manual labels there, or open the workbook in desktop Excel to run the macro. Once helper values exist, filtering them in the web app works like filtering other text values.

On Windows, Ctrl+5 toggles strikethrough for a selected cell or text selection. In Excel for Mac, the usual shortcut is Command+Shift+X. Filter shortcuts can differ by platform; the ribbon route Data > Filter is the straightforward option if a keyboard shortcut does not match your setup. The shortcut changes formatting only—it does not add a filterable status value.

Frequently Asked Questions

Can Excel filter by strikethrough directly?
No. Excel’s standard filter menus do not provide a strikethrough condition. Create a helper value that records the formatting state, then filter that value.

Can I filter strikethrough using Filter by Color?
No. Filter by Color can filter by fill or font color, but it does not filter by the strikethrough font effect. A different font color may be useful as a separate convention, but it is not the same as detecting strikethrough.

Will the VBA helper update when I add or remove strikethrough?
Not automatically. The macro writes a snapshot of the formatting into adjacent cells. Run it again after changing formatting, or maintain the helper status yourself.

Can I do this in Excel for the web?
You can filter a helper column in Excel for the web, but you cannot run VBA macros there. Add the status values manually or use desktop Excel to create them.

Does strikethrough delete a value or remove it from calculations?
No. It changes how the cell or selected characters look. The underlying value remains, so formulas and searches can still use it unless you separately change the data or formula logic.

Which method should you choose?

Use manual helper labels for a small list, a VBA-generated helper column for a large one-time classification in desktop Excel, and Find by formatting when your immediate goal is simply to locate matching cells. For a workbook that people update regularly, a dedicated status field is usually the clearest long-term solution. It turns a visual cue into data Excel can filter directly and makes the meaning of each row easier to maintain.

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.