No—not directly. Excel for Microsoft 365 on Windows can filter a range by values, cell color, font color, and icons, but its standard filter menu has no option for bold font. To filter rows marked with bold text, add a helper column that records which rows contain bold cells, then filter that column; you can fill it manually or use a short VBA macro.
What Excel’s filter can and cannot detect
Excel’s AutoFilter is designed to sort and display records based on field values. Open a filter dropdown and you can select particular entries, search for text, or use options such as Text Filters and Number Filters. Depending on the formatting in the column, the dropdown can also offer Filter by Color, including cell fill color and font color, as well as icon filtering.
Bold is different: it is a font attribute, not a value that AutoFilter exposes as a filter condition. There is no built-in “Filter by Bold” command in the ordinary filter dropdown. This remains true even if you can clearly see that some entries are bold. Sorting by a cell’s format is available in desktop Excel through the Sort dialog, but sorting is not the same as hiding all non-bold rows, and it is not a direct bold filter.
That distinction matters when a worksheet uses bold to communicate something important. Formatting can be useful to people scanning a sheet, but filters work most reliably when the meaning is represented in a field too—for example, a Status column containing “Urgent” or “Standard.”
Best no-code approach: add a status column
If you are building or maintaining the worksheet, the simplest dependable method is to add a column that records why a row is bold. For example, a list of invoices might have columns for Invoice, Due date, Amount, and Follow-up. Instead of relying only on bold invoice numbers, add a Follow-up status field with values such as “Required” and “No.” You can then use the filter arrow on that field to show the rows that need attention.
This approach is more useful than filtering formatting alone because the label explains what the formatting means. It also lets you filter, sort, count, and share the information without asking other users to infer the significance of bold text. If a bold entry means “approved,” use an Approval field; if it means “overdue,” use a Due status field. Choose a value that reflects the actual business rule, rather than merely recording an appearance.
For an existing worksheet where the bold formatting is the only record of the distinction, you can use Excel’s Find feature to locate bold cells. Press Ctrl+F on Windows, choose Options, and use the Format controls to specify bold font formatting. You may set the format through the Font tab or choose a format from a cell, depending on the dialog layout. Find All can identify matching cells, but it does not turn the result into a filter condition. You still need to mark the matching records in a helper column or use a macro to do that systematically.
Use a VBA macro to create a filterable helper column
For a one-time conversion of existing formatting, a small VBA macro can inspect each data cell and write “Bold” or “Not bold” in an adjacent helper column. The example below assumes headers are in row 1, the cells to inspect are in column A, and column B is available. It checks the displayed bold formatting, so it can also recognize bold applied by conditional formatting.
- Save a copy of the workbook first. The macro writes into column B, so make sure that column is empty or change the helper-column references in the code.
- In desktop Excel for Windows, open the Visual Basic editor with Alt+F11. Choose Insert > Module and paste the code into the module.
- Run
MarkBoldRowsfrom the editor, or return to Excel and run it from the Macros dialog. If the Developer tab is not shown, enable it through File > Options > Customize Ribbon and check Developer. - Back on the worksheet, select the data range and choose Data > Filter if filter arrows are not already present. Open the helper-column dropdown and select “Bold” to show only those records.
Sub MarkBoldRows()
Dim ws As Worksheet
Dim lastRow As Long
Dim cell As Range
Set ws = ActiveSheet
lastRow = ws.Cells(ws.Rows.Count, "A").End(xlUp).Row
If lastRow < 2 Then Exit Sub
ws.Range("B1").Value = "Bold status"
For Each cell In ws.Range("A2:A" & lastRow)
If cell.DisplayFormat.Font.Bold Then
cell.Offset(0, 1).Value = "Bold"
Else
cell.Offset(0, 1).Value = "Not bold"
End If
Next cell
End Sub
The macro assumes every record has a value in column A, so the last used row is determined from that column. If your inspected data is in another column, change the column letter in the last-row calculation and the inspection range. Also change the helper-column destination if B contains data. Do not run it on a worksheet where those cells contain information you need to keep.
What the macro does—and what to watch for
The macro reads each cell’s displayed font formatting and writes a text label beside it. It does not remove bold formatting, change the source values, or create a live formula. If you later make cells bold or unbold, run the macro again to refresh the labels. A helper column is a snapshot of the formatting at the time the macro ran, not an automatically updating filter rule.
Macros cannot be undone with Ctrl+Z. That is why saving a separate copy before running one is important. Excel may also block a macro depending on your security settings; use macros only in workbooks and code you trust, and do not lower security protections just to run an unfamiliar file. When distributing the workbook, remember that recipients may need to enable macros to run them, although they can still filter helper values that have already been written.
If the records are in an Excel table, add the helper field as a table column and use that column’s filter arrow. If the sheet already has filters, check that the helper column is included in the filtered range. Otherwise, Excel may create a separate filter range or leave the new column outside the existing one, making the result confusing.
Bold text from conditional formatting
Bold text may be applied directly using the Bold button, or it may appear because a conditional formatting rule changes the font when a condition is met. These cases can look identical on screen, but they are not necessarily stored the same way. A macro that checks only a cell’s basic Font.Bold property may miss formatting supplied by a conditional formatting rule.
The sample uses DisplayFormat.Font.Bold, which reads the cell’s displayed font style in a VBA procedure. That makes it appropriate when the question is whether a cell currently looks bold, including when a conditional formatting rule is responsible. The result still depends on the rule’s current conditions. If values change and the rule changes which cells appear bold, rerun the macro to update the helper column.
Often, the cleaner solution is to filter the underlying condition rather than the visual effect. If conditional formatting makes a row bold whenever its status is “Urgent,” filter the Status field for “Urgent.” That is clearer and avoids having to reconstruct the rule by inspecting the formatting.
Alternatives: color, values, and sorting
If bold was used as a quick visual marker but the rows do not need a special text label, consider replacing or supplementing it with a filter-friendly field. A category, checkbox-style Yes/No value, or short status makes the distinction explicit. You can keep the bold styling as a visual cue while filtering by the field.
- Filter by font color: If the marker can be represented with a unique font color, use the filter dropdown’s Filter by Color option. This filters color, not boldness, and it is only useful if the color meaning is consistent.
- Filter by cell color: A fill color can also be used as a visual marker and may be available under Filter by Color. As with font color, it does not identify bold text automatically.
- Sort by formatting: Desktop Excel’s Sort dialog can sort by cell or font formatting in supported cases. This can group visually marked records, but it does not hide the rest of the rows as a filter does.
- Filter by the original rule: When formatting signals a value or condition already present in the row, filter the relevant value field rather than the format.
Using a color instead of bold is not always a good trade-off. Color alone can be less accessible, and worksheets may print or display differently. A descriptive status column is usually the most robust option when the distinction matters to other people or will be used repeatedly.
Excel for Mac and Excel for the web
The standard filter menu in Excel for Mac also does not provide a direct filter-by-bold command. VBA is supported in desktop Excel for Mac, although the interface and keyboard shortcuts differ from Windows; use the Developer tab’s Visual Basic command or the Mac VBA editor shortcut available for your keyboard configuration. The code may need adjustment if the worksheet layout differs, just as it would on Windows.
Excel for the web does not run VBA macros. You can still use a helper column whose values already exist and filter it in the browser, or add explicit labels manually. For a workbook that needs formatting-based processing, open it in desktop Excel to run the macro, then save the resulting helper values so they can be filtered elsewhere.
Frequently Asked Questions
Can I filter bold cells in Excel without VBA?
Not directly with the standard filter menu. You can enter a helper label manually and filter that label, or use Find to locate bold cells before recording the distinction in a helper column.
Can Excel filter by font color instead?
Yes. If a column contains font colors, open its filter dropdown and look for Filter by Color. This filters by the chosen color, not by whether the font is bold.
Will the macro detect bold from conditional formatting?
The sample checks DisplayFormat.Font.Bold, which reads displayed formatting in VBA and can detect bold supplied by conditional formatting. Run it again after changes that affect which cells the rule formats.
Does Excel for the web support filtering bold text?
No direct bold filter is available there, and Excel for the web cannot run VBA. You can filter a helper column containing labels that were entered manually or created in desktop Excel.
Why did the macro put the wrong labels beside my records?
Check that the cells to inspect are in column A, headers are in row 1, and column B is the intended helper column. The example determines its final row from column A and writes its results one column to the right.
Related
- Excel Not Responding? How to Save Your Work
- Excel Not Responding? Recover an Unsaved File
- Excel Nested Group Rows: How to Create and Use Them
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- HLOOKUP With Multiple Criteria: Formulas and ExamplesHLOOKUP does not accept separate criteria arguments, but you can search by multiple criteria by joining the criteria…
- How to Auto Number Rows in Excel: Formulas and FillTo auto number rows in Excel, enter a row-based formula in the first cell of your numbering column…
- VLOOKUP Excel: Extended Uses, Examples, and LimitsVLOOKUP can do more than retrieve one value from a simple list: it can use exact or approximate…
- Add a Sort List in Excel: Create a Custom OrderTo add a custom sort list in Excel for Microsoft 365 on Windows, go to File > Options…
- Excel Formula for High and Low Values: MIN and MAXIn Excel, use =MIN(B2:B10) to find the lowest number in a range and =MAX(B2:B10) to find the highest.…
- Power BI DAX Concatenate: Examples and UsageIn Power BI DAX, join two text values with the ampersand operator (&) or the CONCATENATE function; to…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.