Filter Only Bold Text in Excel with a Helper Column

Formulas & functions · Updated November 20, 2026

To filter for bold cells in Excel, add a helper column that labels each cell as Bold or Not bold, then use Excel’s regular filter on that label. Excel for Microsoft 365 on Windows does not provide a built-in AutoFilter option for bold font, so the practical method below uses a short VBA macro to create the labels. You can then filter the rows without changing the original formatting.

What You’ll Need

  • Excel for Microsoft 365 on Windows with a workbook saved as an Excel macro-enabled workbook (.xlsm) if you want to keep the macro in the file.
  • A single column of data to check, with a header immediately above the first data cell. The steps assume you want to filter rows based on whether the cell in that column is bold.
  • A blank column immediately to the right of the selected data column for the helper labels. If that column contains information, choose another blank column and adjust the macro or move the helper labels after they are created.
  • Permission to run macros. If your organization blocks VBA, use the manual alternative in the troubleshooting section or ask your administrator about approved options.

Step-by-Step

  1. Make a copy and check the data. Save a backup before running code that writes into the worksheet. Confirm that the column you want to check has one header cell, followed by the data cells, and that each row represents one record. For example, if column C contains notes, the header is in C1, and the records run from C2 to C50, the macro should be run on C2:C50. Do not include the header in the selection.
  2. Make sure the helper column is clear. The macro puts a “Bold status” header in the cell beside your data header and writes a status beside each selected cell. If your selected cells are C2:C50, it will use D1:D50. Move or copy anything already in those cells before continuing. The macro checks for existing contents and stops rather than deliberately overwriting them.
  3. Open the Visual Basic Editor. In Excel for Windows, press Alt+F11. If the shortcut is unavailable, use the Developer tab and choose Visual Basic. If the Developer tab is hidden, enable it through File > Options > Customize Ribbon, then select Developer. In the Visual Basic Editor, choose Insert > Module to create a standard module.
  4. Paste the macro into the module. Copy the complete code below into the large code pane. It checks the cell-level Bold setting for each selected cell and writes either Bold or Not bold in the next column. If a cell has mixed formatting within its text, Excel may report its bold setting as indeterminate; this macro treats that cell as Not bold.
Sub MarkBoldCells()
    Dim dataCells As Range
    Dim helperCells As Range
    Dim ws As Worksheet
    Dim boldState As Variant
    Dim i As Long

    If TypeName(Selection) <> "Range" Then Exit Sub
    Set dataCells = Selection
    Set ws = dataCells.Worksheet

    If dataCells.Areas.Count <> 1 Or dataCells.Columns.Count <> 1 Then
        MsgBox "Select one continuous column of data cells."
        Exit Sub
    End If
    If dataCells.Row = 1 Or dataCells.Column = ws.Columns.Count Then
        MsgBox "Leave a header above the data and a column to its right."
        Exit Sub
    End If

    Set helperCells = dataCells.Offset(0, 1)
    If Application.CountA(helperCells.Cells(1, 1).Offset(-1, 0).Resize(dataCells.Rows.Count + 1, 1)) > 0 Then
        MsgBox "The helper column cells are not empty. Clear them or choose another column."
        Exit Sub
    End If

    helperCells.Cells(1, 1).Offset(-1, 0).Value = "Bold status"
    For i = 1 To dataCells.Rows.Count
        boldState = dataCells.Cells(i, 1).Font.Bold
        helperCells.Cells(i, 1).Value = "Not bold"
        If Not IsNull(boldState) Then
            If boldState = True Then helperCells.Cells(i, 1).Value = "Bold"
        End If
    Next i
End Sub
  1. Select the data cells and run the macro. Return to the worksheet. Select only the cells to inspect, not the header; for the example above, select C2:C50. In the Visual Basic Editor, click inside the macro and press F5, or return to Excel, press Alt+F8, choose MarkBoldCells, and click Run. The adjacent helper column should show a status for every selected row. Save the workbook as .xlsm if you need to retain the macro; the labels themselves remain in the sheet if you save a separate .xlsx copy, but the macro will not.
  2. Turn on filtering for the full data range. Select the entire dataset, including its header row and the new helper column. In this example, select A1:D50 if the original data runs from A to C. Choose Data > Filter. If filter arrows are already on the original range but do not include the helper column, turn Filter off, select the expanded range, and turn it on again. Keep the header row included so Excel uses “Bold status” as the helper field name.
  3. Show only bold rows. Open the filter arrow in the Bold status header. Clear Select All, select Bold, and click OK. Excel hides rows labeled Not bold and displays the records whose selected cell is bold. This filters whole rows; it does not extract only the bold characters from inside a cell.
  4. Restore the complete list when finished. Open the helper-column filter and choose Clear Filter From “Bold status,” or select Data > Clear to clear filters on the sheet. Keep the helper column if you expect to filter again. If you no longer need it, clear the filter first, then delete the helper column or its contents.

The macro checks bold formatting when it runs; it does not update the labels automatically. If you bold or unbold cells afterward, run the macro again. Clear the old helper labels first, or change the macro’s destination to a different empty column, because the safety check is designed to stop when helper cells are already occupied.

Common Mistakes

  • Expecting a native “Bold” filter. Excel’s standard filter menu includes options such as filtering by cell color or font color, but it does not offer a direct bold-versus-not-bold choice. A font color filter is not a substitute: boldness and font color are separate formatting properties.
  • Selecting the header or only some records. If the header is selected as data, it can be labeled incorrectly. If the selection stops before the final record, the remaining rows receive no helper status and may not behave as expected when filtered. Select one contiguous data range, excluding the header.
  • Forgetting the helper field when applying the filter. If the filtered range ends before the helper column, its dropdown will not appear. Reapply Data > Filter to a range that includes the original headers, all data rows, and the helper header and labels.
  • Assuming partial bold text counts as a bold cell. A cell can contain a mixture of bold and regular characters. The macro tests the cell’s overall Font.Bold property, not individual characters, so mixed formatting is not reliably classified as bold. See the FAQ if your goal is to find bold words within a sentence.
  • Saving in a format that drops VBA. The .xlsx format cannot store VBA code. Save as .xlsm to keep the macro, or save an .xlsx copy after creating the helper labels if you only need the results and not the code.

Tips

Use a descriptive helper heading such as “Bold status” rather than leaving the header blank. This makes the filter menu easy to recognize and helps anyone else using the workbook understand why the extra field is there. You can also format the helper column differently from the source data so it is clear that Bold and Not bold are labels, not original values.

For a reusable workbook, keep a copy of the macro in a trusted .xlsm file and run it after formatting changes. The macro writes plain text labels, so sorting or filtering those labels does not alter the source cells’ font settings. If you insert or remove records, select the updated data range and rerun the macro so every row has a current status.

If your records are already an Excel table, add the helper field as a table column and confirm the table includes it before filtering. Depending on how the table was created and where the new column is placed, it may expand automatically; if it does not, use Table Design > Resize Table to include the helper column. Table filter arrows can then filter the Bold status field like any other field.

On Excel for Mac, VBA is available in desktop Excel, though keyboard shortcuts and the editor entry point can vary by keyboard and version. Use the Developer tab’s Visual Basic command, or open the Visual Basic Editor through the Tools > Macro menu if available. Excel for the web cannot run VBA macros; open the workbook in desktop Excel to create the labels. The standard filter is available in desktop Excel for Mac and Excel for the web, but the exact ribbon layout may differ.

Troubleshooting

  • The macro does not appear in the macro list. Confirm that the code is in a standard module, not pasted into a worksheet code window, and that the procedure is named MarkBoldCells. If prompted, enable macros only for a workbook you trust and that you are permitted to use. Managed work devices may block VBA.
  • The macro says the helper cells are not empty. It found content in the adjacent helper range, including its header position. Clear those cells only if you are sure their contents are disposable, or move the source data so there is a blank column to the right. Do not remove unrelated data just to make the macro run.
  • No Bold option appears in the filter menu. Check that the helper column contains the exact label Bold and that the filter range includes its header. If the labels are blank or missing for some rows, rerun the macro on the full data range after clearing the helper cells, then reapply the filter.
  • Rows you expected are marked Not bold. Verify that the entire cell is bold, rather than only a few characters. Also check that you selected the correct column and that the text was not made to look heavier through a different font or conditional formatting. This macro reads the cell’s font setting; it does not evaluate visual appearance or conditional-formatting rules as a general “looks bold” test.
  • You cannot run a macro in Excel for the web. Open the file in desktop Excel for Windows or Mac. If desktop VBA is unavailable, you can inspect cells manually using Home > Find & Select > Find, choose Options > Format, and set a bold font format to search for matching cells. Finding matches this way is not the same as filtering complete rows, so for a repeatable row filter you need a helper field populated by an allowed desktop macro or another approved process.

Frequently Asked Questions

Can I filter bold cells without VBA?
Excel does not have a built-in AutoFilter condition for bold formatting. You can use Find with a bold format to locate matching cells, but that does not create a normal filter that hides all rows without matches. If macros are prohibited, a practical workaround is to add a status column manually and label each row before applying Data > Filter.

Does this filter bold words inside a cell?
No. It classifies a cell based on its overall bold setting and filters the row containing that cell. It does not separate or display only bold characters within a sentence. Mixed bold and regular formatting in one cell may be reported as indeterminate and is treated as Not bold by the macro.

Will the labels change when I change the formatting?
No. Bold and Not bold are static text values written when you run the macro. If you change the formatting, clear the old helper values and rerun the macro on the updated data cells to refresh the results.

Can I use this with an Excel table?
Yes. Add the helper column to the table, make sure the table range includes it, and filter the Bold status field. If the table does not expand to include the new column, use Table Design > Resize Table before filtering.

Can Excel for the web or Mac do this?
Excel for the web supports ordinary filters but cannot run VBA macros. Excel for Mac desktop supports VBA, although editor access and shortcuts can differ from Windows. Run the macro in desktop Excel, then use the helper column’s filter in the version where you are working.

Can I filter by bold and another condition at the same time?
Yes. After filtering the helper field to Bold, use the dropdowns on other columns to apply additional criteria, such as a category or date. Excel combines the active column filters, so the visible rows must satisfy the Bold condition and the other filters.

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.