Excel’s standard filter cannot directly identify or filter rows by bold text. To filter them, add a helper column that records whether each target cell is bold, then filter that column; you can fill the helper manually or use a short VBA macro.
What Excel’s filter can and cannot detect
In Excel for Microsoft 365 on Windows, the filter menu is designed to filter data values and certain visual features, but bold is not one of its available criteria. When you choose Data > Filter and open a column’s dropdown, Excel can offer text, number, and date filters. Depending on the formatting in that column, it can also offer Filter by Color for cell fill, font color, or a cell icon. It does not offer a “bold” condition.
This distinction matters because font color and font weight are separate formatting properties. A red, nonbold cell may be filterable by font color, while a black, bold cell is not filterable simply because it is bold. Applying bold to a cell also does not change its value, so ordinary filters and worksheet formulas that examine values cannot tell that the text is bold.
For a small list, a helper column is usually the simplest answer. It turns a visual property into a regular value such as Bold or Not bold, which Excel’s ordinary filter can handle. The helper does not change the original text or its formatting.
How to filter bold rows with a helper column
Suppose names are in column A, the list has a header in row 1, and some names are bold. Add a header such as Bold status in an unused column, then mark each data row according to the formatting of its name. For example, enter Bold beside bold names and Not bold beside the others. Select the list and choose Data > Filter, or use the filter dropdowns if the data is already an Excel table. Open the Bold status dropdown and select only Bold.
This manual method is often best when there are only a few marked rows or when bold is being used as a human decision rather than a consistent rule. It also avoids macros, which may be blocked by organizational security settings. Keep the helper column beside the records it describes, and include it in the filtered range; otherwise, the labels may not stay aligned with the correct rows when you sort or filter.
- Use a clear, consistent label, such as Bold and Not bold, rather than relying on a blank cell to mean one of the two states.
- Make sure the filter covers every column in the records, including the helper column.
- If the data is an Excel table, add the helper as a table column so its header has a filter dropdown.
- After changing which cells are bold, update the helper values before relying on the filtered results.
The final point is easy to overlook: the helper is a record of the formatting at the time you marked it, not a live connection to the bold style. If someone later changes a cell’s font, the label will not automatically change with it.
Automate the helper column with VBA
For a large list, a macro can inspect a range, write Bold or Not bold into an adjacent helper column, and let Excel filter those labels. The example below checks the displayed bold style, so it can also recognize bold applied by conditional formatting. It assumes the target text is in A2:A100, row 1 contains headers, and column B is available for the helper. Adjust those references before running it.
Sub MarkBoldRows()
Dim ws As Worksheet
Dim sourceRange As Range
Dim cell As Range
Set ws = ActiveSheet
Set sourceRange = ws.Range("A2:A100") ' Change this range as needed
ws.Range("B1").Value = "Bold status" ' Make sure column B is available
For Each cell In sourceRange.Cells
If cell.DisplayFormat.Font.Bold = True Then
ws.Cells(cell.Row, "B").Value = "Bold"
Else
ws.Cells(cell.Row, "B").Value = "Not bold"
End If
Next cell
End Sub
To use it, save a copy of the workbook first, then open the Visual Basic editor from the Developer tab, insert a standard module, paste the code, and run MarkBoldRows. If the Developer tab is hidden, enable it through File > Options > Customize Ribbon on Windows. After the macro runs, apply or refresh the filter and choose Bold in column B. Save the workbook as an Excel Macro-Enabled Workbook (.xlsm) if you need to keep the macro in that file.
Macros cannot be undone with Ctrl+Z, so save a copy before running one. The sample overwrites B1 and the cells in B2:B100; do not run it with important data in those cells. It checks displayed formatting when it runs, but it does not continuously monitor changes. Run it again if the bold formatting changes. Excel for the web cannot run VBA macros; use desktop Excel for this method.
Using Find to locate bold cells
Excel’s Find dialog can search for cells with particular formatting, which can help you identify bold entries without a macro. Press Ctrl+F, choose Options, open the Format menu, and select Choose Format From Cell. Click a cell that has the bold formatting you want to find, then choose Find All. The search results can help you review where that formatting appears.
Finding cells is not the same as filtering records, however. Find does not create a filter criterion or automatically mark the matching rows in a helper column. For a short list, you can use the results as a guide and label the corresponding rows manually. If you need a repeatable filtered view, the helper-column approach is more dependable.
Why a formula alone will not detect bold
Worksheet formulas such as IF, COUNTIF, and FILTER work with cell values and other supported criteria; they do not provide a normal worksheet function that asks whether another cell is bold. A formula that returns text based on a cell’s value therefore cannot detect formatting that someone applied separately. This is why a helper formula is not a direct substitute for the macro or manual marking.
There are old macro-function techniques sometimes suggested for reading formatting, but they add setup and maintenance complications and are not ordinary worksheet formulas. For a workbook shared with others, a clearly labeled helper column is easier to inspect. If the bold style represents a business rule, consider storing that rule as data—such as a Status or Priority field—instead of encoding it only as typography.
Common problems and how to avoid them
- Confusing bold with font color: Filter by Color can filter a font color, not the bold weight. A font-color filter will not necessarily return every bold cell.
- Forgetting to refresh the helper: Changing a cell to bold does not update a manually entered label or a macro’s earlier result. Re-mark the rows after formatting changes.
- Filtering only part of the records: If the helper column is outside the filter range, Excel may not treat it as part of the same list. Include all record columns or use a table.
- Overwriting data with the macro: The sample uses column B for labels. Change the output column if B already contains information, and change the header cell too.
- Expecting bold to mean important: Bold is a visual choice, and different people may apply it inconsistently. A value-based field is safer when the distinction affects reporting or decisions.
- Not seeing the expected results after a sort: Make sure the helper labels and source records were sorted together. Sorting just one column can separate labels from the rows they describe.
If the font appears bold because of a conditional-formatting rule, the macro’s DisplayFormat check is intended to read the displayed result. If you only want to test directly applied formatting, the code can instead use cell.Font.Bold. In either case, run the macro again after changing the style or the rule that controls it.
Excel for Mac and Excel for the web
The underlying limitation applies across Excel: a standard filter does not have a bold-text criterion. On Mac, Excel also supports VBA, although the exact keyboard shortcuts for opening the editor can differ by keyboard and settings; use the Developer tab’s Visual Basic command if available. The macro code itself may need adjustment if the workbook’s sheet layout or target range differs.
Excel for the web supports ordinary filtering but does not run VBA macros. In a browser, use a manually maintained helper column, or open the workbook in desktop Excel to run the macro and then save the results. If the file is shared, tell collaborators whether they should update the helper labels themselves, since the labels do not automatically track formatting changes.
When to use a different method
Choose a manual helper when the list is small, the bold entries change infrequently, or macros are not allowed. Choose VBA when there are many rows and the same check must be repeated, provided desktop macros are permitted and the source range is well defined. If bold is only one of several visual cues, consider converting the underlying meaning into a proper data column and filtering that instead.
For instance, if bold names mean that a customer needs follow-up, add a Follow-up column with values such as Yes and No. That field is clearer than formatting alone, works with filters and formulas, and remains meaningful when data is exported or viewed in a different application. Bold can still be used as a visual aid, but it no longer carries the only copy of the information.
Frequently Asked Questions
Can Excel filter by bold text directly?
No. Excel’s standard filter menu does not include bold as a filtering condition. Use a helper column containing labels such as Bold and Not bold, then filter that column.
Can I use Filter by Color for bold cells?
Not just because the text is bold. Filter by Color can filter font color, cell fill color, or icons when available, but font weight is a separate property.
Will a formula detect whether a cell is bold?
There is no standard worksheet formula that directly checks another cell’s bold formatting. A manually maintained helper or a macro can turn that formatting into a value Excel can filter.
Does the VBA method recognize conditional formatting?
The example uses DisplayFormat.Font.Bold to check the displayed style, including formatting applied through conditional formatting. It records the result only when you run the macro, so run it again after the style changes.
Can I filter bold text in Excel for the web?
You can filter a helper column in Excel for the web, but the web app does not run VBA. Create or update the helper manually in the browser, or use desktop Excel to run the macro.
Related
- Excel Custom Number Format with Text: How It Works
- Excel Custom Number Format: Show Zero as a Dash
- Excel Custom Number Format for Millions
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- XLOOKUP Excel Column Match: Find a Column by HeaderTo match a value in an Excel column and return a value from another column, use XLOOKUP with…
- Excel Time Formulas: Calculate Overnight PM-to-AM HoursIf A2 contains a PM start time and B2 contains the following AM finish time, enter =MOD(B2-A2,1) to…
- SUMIF Excel Cell Reference: Syntax, Examples, and FixesWith criteria in A2:A6 and amounts in C2:C6, enter =SUMIF(A2:A6,"North",C2:C6) to add the amounts for rows marked North;…
- DAX Formula in Excel to Remove Duplicates: What WorksThere is no DAX formula in an Excel worksheet that deletes duplicate rows. For a live list of…
- Excel Formula for the Lesser of Two Values in a CellWith the two numeric values in cells A2 and B2, enter =MIN(A2,B2) in the cell where you want…
- Excel Text Handling: Formulas, Formatting, and FixesExcel text handling means entering, cleaning, combining, splitting, and displaying text without accidentally changing its meaning. In Microsoft…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.