Yes. In Excel for Microsoft 365 on Windows, you can search the items shown in a slicer by clicking the magnifying-glass icon in its header and entering text. The search narrows the visible slicer items; click a matching item to apply that slicer filter to the associated table or PivotTable.
How to search in an Excel slicer
Start with a slicer that is already connected to an Excel table or PivotTable. The search control is part of the slicer header, so make sure the header is displayed. Then use these steps:
- Click the slicer you want to use. Its contextual Slicer tab appears on the ribbon.
- Look in the slicer header, usually near its upper-right corner, for the magnifying-glass icon. Click it to show the search box.
- Type a word or part of a label. Excel reduces the visible buttons to items that match the search.
- Click one or more displayed items to filter the connected data. Searching narrows the list of choices; it is selecting the item that applies the filter.
- Clear the search text when you want to see the full list of slicer items again. Clear the slicer selection separately if you also want to remove its filter.
For example, a slicer for a Product column might contain labels such as Alpine Jacket, Alpine Socks, and Trail Bottle. Searching for Alpine makes the matching labels easier to find. Selecting Alpine Jacket then filters the connected report to that item; merely typing Alpine is not the same as choosing every matching product.
What slicer search actually searches
A slicer represents distinct values from one field, such as Region, Category, or Salesperson. Its search box looks through the item labels in that slicer. It is not a workbook-wide search, and it does not search every cell in the source data, formulas, comments, or other fields. To find a value in an unrelated column, use that column’s filter or search the worksheet instead.
Search is useful when a slicer contains many buttons and scrolling takes too long. It changes which buttons are displayed while you look for a choice. The slicer’s selection still controls the report, and the search text itself does not create a new category or change the source data.
Remember that the available choices depend on the data and the slicer’s connections. A slicer can show items for its field, but it cannot make a missing value appear if that value is not part of the relevant source or is excluded by the way the report is configured. For PivotTables, other active filters can also affect which items are available or how they appear.
Which Excel slicers support search?
Slicers can filter Excel tables and PivotTables. In supported Excel desktop versions, the header search control can help locate items in either kind of slicer. The exact appearance and availability can depend on the Excel version and platform, so use Excel for Microsoft 365 on Windows as the reference point for the steps above.
Search does not turn every report control into a slicer. A timeline, for example, is a separate control designed for dates; it lets you choose time periods rather than search a list of ordinary text labels. Likewise, a slicer for a date field searches the slicer’s displayed item labels; it is not a substitute for a timeline when you need to select a date range.
Slicers can also connect to more than one PivotTable when those reports share a compatible data source or PivotTable cache and the reports are connected in the workbook. If selecting a searched item changes one report but not another, check the slicer’s report connections rather than assuming search is broken. A slicer only filters the reports to which it is connected.
Why the search box may be missing
If you cannot see the magnifying glass, first check whether the slicer header is displayed. Select the slicer, open the Slicer tab, and choose Slicer Settings. Look for the Display header option and turn it on if it is off. The header contains the slicer title and controls, including search where supported.
Also check that the object is actually a slicer. A filter arrow in a table heading, a PivotTable field dropdown, and a timeline can look like related filtering tools, but they have different controls. If you are using Excel for Mac or Excel for the web, the interface and feature availability can vary by release. If the search icon is not offered in your version, use the field’s filter menu or open the workbook in Excel for Microsoft 365 on Windows.
- Confirm that you selected the slicer itself, not a cell beside it.
- Check whether the header is hidden or the slicer is too narrow to make its controls obvious.
- Make sure the workbook is open in a version of Excel that supports the control you are looking for.
- If the slicer filters nothing, verify that it is connected to the intended table or PivotTable and that the source data contains the expected item.
Search versus selecting and filtering
It helps to separate three actions: searching for a label, selecting a slicer button, and clearing a filter. Search is a way to locate buttons. Selecting a button applies the corresponding filter. Clearing the selection removes that slicer’s choice; clearing the search text simply restores the full list of buttons. Confusing the last two actions is a common reason people think the filter has not cleared.
Depending on the slicer settings and the way its source is built, you may be able to select multiple items. In that case, search can help locate each item, but it does not change the selection rules. Use the slicer’s multi-select control or the selection behavior available in your Excel version when choosing several values. If you only want one category, click that category and check the report to confirm the result.
When a selection produces no visible records, the chosen value may not have matching rows under the other filters currently applied. Clear other slicers or report filters temporarily to distinguish that situation from a connection problem.
Slicer search compared with other Excel filters
Use slicer search when you want a visible, clickable control for filtering a report, especially when the item list is long or colleagues need to see the active choices. Slicers are easy to scan and make filter state more apparent than a small dropdown. They also take up worksheet space, so they are not always the best choice for a compact data-entry sheet.
For an Excel table, the filter dropdown in a column heading is often a better choice for occasional filtering. Turn on filtering from Data > Filter if it is not already enabled, then open the relevant column’s dropdown and use its search box when available. This searches that column’s filter choices without placing a separate slicer object on the worksheet.
For a PivotTable, you can also filter a field from its dropdown. That works well when you do not need a dashboard-style control. For a quick search of worksheet content rather than a filter, use Find (Ctrl+F on Windows; Command+F on Mac). Find locates matching content; it does not filter the records in the same way as a slicer.
Practical tips for long slicer lists
Search is most helpful when slicer labels are consistent and understandable. If a list contains values such as N, North, and Northern, users may not know which one to select. Clean up the source labels when appropriate, refresh a PivotTable after changing its source data, and give the slicer a clear caption so the field being filtered is obvious.
For a dashboard, consider whether users need every item visible at once. You can resize a slicer or arrange its buttons in columns using the controls on the Slicer tab. A search box is especially useful when a long list would otherwise require extensive scrolling, but it should not be the only clue to what the slicer does. A descriptive heading and an easy way to clear selections make the report easier to use.
Before sharing a workbook, set the slicer to a sensible starting selection and check that its connected reports respond as intended. If the source data changes, refresh the relevant PivotTable where needed, then confirm that new labels appear among the slicer choices. Search can locate available labels; it cannot refresh stale report data.
Frequently Asked Questions
Can you search for part of a slicer item?
Yes. Enter a word or part of a label in the slicer search box to narrow the displayed choices to matching items. The search is for slicer labels, not arbitrary text across the workbook.
Does typing in a slicer search box filter the report automatically?
No. Typing narrows the visible buttons so you can find an item. Click a matching button to apply that item as a filter. Clear the search and clear the selection are separate actions.
Can I search a slicer connected to an Excel table?
Yes, when the slicer and search control are available in your Excel version. Table slicers filter the table by the field represented in the slicer, and the search box helps locate that field’s item labels.
Why does my slicer show no matching results?
The typed text may not match any displayed item, or other active filters may affect the available choices. Clear the search text, check the source values, and temporarily remove other filters to narrow down the cause.
Can slicer search find a value in another column?
No. It searches the items for the slicer’s own field. Add or use a slicer for the other field, use that field’s filter dropdown, or use Find if your goal is to locate worksheet content rather than filter a report.
Related
- ISERROR in Excel: How It Works and When to Use It
- ISBLANK in Excel: Examples and How It Works
- ISNUMBER in Excel: Check Whether a Cell Holds a Number
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Column to CSV: Save One Column CorrectlyTo save one Excel column as a CSV, copy the column or the exact range you need into…
- Compare and Merge Documents in Word: A Step-by-Step GuideTo compare two Word files, open Word and choose Review > Compare > Compare, then select the original…
- DAX Measure Switch Based on a Column Value in Power BIYes. In a DAX measure, use SWITCH to return a different measure for each value, and use SELECTEDVALUE…
- Python pandas Excel Merge: Join Workbooks and SheetsTo merge Excel data with Python, read each worksheet into a pandas DataFrame with pd.read_excel(), then use pd.merge()…
- Insert a Row Every Other Row in Excel: Easy MethodsYes. In Excel for Microsoft 365 on Windows, you can insert a blank row between existing rows by…
- How to Insert a Signature in Word on a Mac: 3 WaysTo insert a signature in Word on a Mac, add an image of your handwritten signature with Insert…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.