How to Filter Out Bold Text in Excel

Formulas & functions · Updated November 20, 2026

To filter rows according to whether a cell is bold, add a helper column that labels each row “Bold” or “Not bold,” then use Excel’s AutoFilter to show the label you want. Excel for Microsoft 365 on Windows does not offer bold font weight as a direct AutoFilter criterion, so the VBA method below checks the formatting and gives you a filterable result.

This approach works when you want to show only rows whose value in a particular column is bold—or hide those rows by showing only “Not bold.” It checks the cell’s current font formatting, not the text’s meaning. If you only need to find bold cells rather than filter rows, Excel’s Find by Format feature is a simpler option.

What You’ll Need

  • Excel for Microsoft 365 desktop on Windows. VBA macros do not run in Excel for the web.
  • A worksheet with one header row and a contiguous block of data.
  • A blank helper column at the right edge of that data, with a header such as “Bold status.”
  • Permission to run macros. If your organization blocks macros, ask your administrator about approved options.

Save a copy of the workbook before running VBA. The macro writes labels into the helper column, and macro actions cannot be reversed with Ctrl+Z. If you save the macro in the workbook, use the Excel Macro-Enabled Workbook format (.xlsm).

Step-by-Step

  1. Prepare the table. Make sure the data has one header row, with no completely blank rows or columns breaking up the range. Add a new column immediately to the right of the data, and enter a heading such as “Bold status” in its header cell. Leave the helper column’s data cells empty. If another field currently sits to the right of the column you want to check, insert a blank column after that field or rearrange the table so the helper column is at the far right. The macro writes into the last column of the selected range.
  2. Select the complete range. Select the table’s header row and all its data rows, including the new helper column. For example, if your headings are in A1:E1 and the records run through row 50, select A1:E50. Do not select the entire worksheet, and do not omit the helper column. The macro assumes the first selected row contains headings and the final selected column is the helper.
  3. Open the Visual Basic Editor. On Windows, press Alt+F11. If the Developer tab is visible, you can also choose Developer > Visual Basic. On a Mac, use Option+F11; depending on your keyboard settings, you may need Fn+Option+F11. Excel for the web does not have the desktop Visual Basic Editor, so use the Windows or Mac desktop app for this method.
  4. Add a standard module. In the Visual Basic Editor, choose Insert > Module. A blank code window appears. Paste the macro below into that window. It examines one column in the selected range and writes a status beside each data row in the range’s last column.
Sub MarkBoldStatus()
    Dim dataRange As Range
    Dim answer As String
    Dim sourceColumn As Long
    Dim rowIndex As Long
    Dim cellBold As Variant

    ' Check that one rectangular range is selected.
    If TypeName(Selection) <> "Range" Then Exit Sub
    Set dataRange = Selection
    If dataRange.Areas.Count <> 1 Then
        MsgBox "Select one continuous table range."
        Exit Sub
    End If
    If dataRange.Rows.Count < 2 Or dataRange.Columns.Count < 2 Then
        MsgBox "Select the header, data rows, and a helper column."
        Exit Sub
    End If

    ' Ask which selected column contains the font formatting to check.
    answer = InputBox("Enter the column number within your selection to check. " & _
                      "The first selected column is 1.")
    If answer = vbNullString Then Exit Sub
    If Not IsNumeric(answer) Then
        MsgBox "Enter a column number."
        Exit Sub
    End If
    sourceColumn = CLng(answer)
    If sourceColumn < 1 Or sourceColumn >= dataRange.Columns.Count Then
        MsgBox "Choose a data column, not the final helper column."
        Exit Sub
    End If

    ' Label each data row; the final selected column is the helper column.
    For rowIndex = 2 To dataRange.Rows.Count
        cellBold = dataRange.Cells(rowIndex, sourceColumn).Font.Bold
        If IsNull(cellBold) Then
            dataRange.Cells(rowIndex, dataRange.Columns.Count).Value = "Mixed"
        ElseIf CBool(cellBold) Then
            dataRange.Cells(rowIndex, dataRange.Columns.Count).Value = "Bold"
        Else
            dataRange.Cells(rowIndex, dataRange.Columns.Count).Value = "Not bold"
        End If
    Next rowIndex
End Sub
  1. Run the macro. Return to Excel and make sure the same complete range, including the header and helper column, is still selected. In the Visual Basic Editor, click inside the macro and press F5, or return to Excel and press Alt+F8, select MarkBoldStatus, and choose Run. When prompted, enter the position of the column to check within your selected range: the first selected column is 1, the second is 2, and so on. Do not enter the worksheet’s letter unless it happens to match that position. For example, if your selection starts at column A and the bold formatting to check is in column C, enter 3. If the selection starts at B and the target is D, enter 3 as well.
  2. Check the helper results. The macro leaves the header alone and fills the helper column for each data row. “Bold” means the checked cell has bold font formatting; “Not bold” means it does not. “Mixed” is included as a safeguard for formatting Excel reports as mixed or indeterminate. Confirm a few rows against the original cells before filtering. If labels appear in the wrong place, undo is not available for the macro action; restore your saved copy or clear the helper results and rerun the macro with the correct selection.
  3. Turn on filtering. If the data is already an Excel table, it normally has filter arrows in its headers. Confirm the helper column is part of the table; if it is not, resize the table from Table Design > Resize Table to include it. For a normal range, select the whole range, including the helper header, and choose Data > Filter. Filter arrows should appear in the header row.
  4. Show or exclude bold rows. Open the filter arrow on the “Bold status” header. Clear Select All, select “Not bold,” and click OK to hide rows whose checked cell is bold. Choose “Bold” instead to show only bold rows. Choosing both values shows both categories, so it does not remove either one. Clear the filter when you want to see all records again.

The helper values are a snapshot: Excel does not automatically recalculate them when you change font formatting. If you bold or unbold cells later, run the macro again over the same range to refresh the labels, then reapply or adjust the filter.

Common Mistakes

  • Expecting a direct “Bold” filter. AutoFilter can filter by values and, in applicable cases, cell or font color, but it does not provide a font-weight criterion for bold versus regular text. A font-color filter is not the same as a bold filter: cells can be bold in several colors, or share a color while using different weights.
  • Entering the wrong column number. The prompt uses the position inside your selection, not the worksheet column letter or number. Count from the selection’s left edge. If the range begins at column C, its first column is still position 1.
  • Leaving the helper column out of the selection. The macro writes its results to the final selected column. If the helper column is not included, it may put labels in an existing data field. Always check the selected range before running the macro.
  • Including extra rows or selecting multiple blocks. The macro treats the first selected row as the heading and checks every row below it. A title row above the headers, a total row at the bottom, or multiple separate selections can lead to incorrect labels or a warning. Select one rectangular range containing only the table header and records.
  • Assuming the filter updates formatting changes. The helper cells contain text, not live formulas. Changing a cell from bold to regular after the macro runs does not change its label until you rerun the macro.
  • Overlooking bold caused by conditional formatting. The macro reads the cell’s font formatting through VBA. If the appearance is controlled by conditional formatting, check the results carefully; formatting rules and displayed appearance can be more complicated than directly applying Bold on the Home tab.

Tips

  • Choose one field as the rule. Filtering based on a particular column is usually easier to interpret than asking whether any cell anywhere in a row is bold. For instance, you might check bold customer names in column A, then filter the helper labels for “Bold.”
  • Keep the helper column visible while checking. It makes the filter’s logic clear to anyone using the workbook. You can rename its heading to something more specific, such as “Name is bold,” after the macro runs.
  • Use a table for ongoing work. Excel tables make it easier to keep filter controls with the data and include added rows. Make sure the helper field is included in the table, and rerun the macro for new rows because the status labels are not generated automatically.
  • Use Find if you only need to locate bold text. Press Ctrl+F, choose Options, open the Format menu, and set the font style to Bold in the Find Format dialog. Choose Find All to list matching cells. This locates formatted cells; it does not create a reliable row-level filter, which is why the helper-column method is better when you need to filter records.
  • Preserve the original formatting. Avoid using Format Painter or changing font weight to make the results easier to see. The macro bases its labels on the formatting in the chosen source column, so changing that formatting changes what the labels should mean.
  • On a Mac, keep to the desktop app for VBA. Excel for Mac supports VBA, though keyboard shortcuts and macro security prompts can differ. The Excel for the web app can display and filter the resulting helper values but cannot run this VBA macro.

Troubleshooting

The macro does not appear in the macro list: Confirm that the code was pasted into a standard module using Insert > Module, not into a worksheet’s code window. Check that the macro name is MarkBoldStatus and that the workbook is open in desktop Excel. If macros are disabled by a security policy, do not lower the security setting without approval; ask your IT administrator for guidance.

The macro says to select a continuous range: Select the table as one rectangle. Click and drag across the header, data rows, and helper column, or click a cell in the table and use the range-selection tools. Do not Ctrl-click separate areas.

The results are shifted or overwrite other data: The final column of the selected range is always used for status labels. Restore the workbook copy if needed, add a dedicated blank helper column at the far right, and select the range again with that column included. Verify the source-column number against the selected range’s left edge before running the macro.

There are no filter arrows: Select the complete range, including its header and helper field, then choose Data > Filter. Check that the header row is present and that the range does not contain a blank row separating the header from the records. If you are using an Excel table, confirm the helper column is inside the table rather than merely beside it.

A bold-looking cell is labelled “Not bold”: Select the source cell and inspect its font settings on Home > Font. It may look heavier because of a font face, a conditional formatting rule, or another display effect rather than direct bold formatting. If the bold appearance comes from conditional formatting, inspect the rule using Home > Conditional Formatting > Manage Rules and decide whether to base the filter on the rule’s underlying value instead.

You changed the formatting but the filter stayed the same: That is expected because the helper values are static. Rerun the macro with the full range selected to refresh them, then choose the desired status from the helper column’s filter menu again.

Frequently Asked Questions

Can Excel filter directly by bold text?
Not by bold font weight in the standard AutoFilter menu. Use a helper column to label rows based on formatting, then filter those labels. Filtering by font color, where available, does not identify bold text unless color is deliberately used as a separate marker.

How do I filter out bold rows and keep only regular text?
Run the macro against the column whose bold formatting matters, then filter the helper column to show only “Not bold.” Excel hides the rows labelled “Bold” while the filter is active.

Can I check whether any cell in the row is bold?
The steps above check one selected field per row. To check multiple fields, the macro would need to be adapted to examine each relevant cell and mark a row bold if any of them is bold. Decide which columns count first, since checking every cell—including notes or the helper field—may produce unintended matches.

Will the filter update when I bold or unbold a cell?
No. The macro writes ordinary text labels, so changing formatting does not update them automatically. Run the macro again to refresh the helper values, then adjust the filter if needed.

Can I do this in Excel for the web or without macros?
Excel for the web cannot run VBA. You can use the desktop app to create the helper labels and then filter those labels in the web app. Without VBA, Ctrl+F with a Bold format criterion can find matching cells, but it does not provide the same automatic row-by-row helper filter.

Does the macro change the text or bold formatting?
No. It reads the font’s bold setting in the chosen source column and writes “Bold,” “Not bold,” or “Mixed” in the selected range’s final column. It does not alter the source cell’s value or font formatting.

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.