To insert a slicer in Excel for Microsoft 365 on Windows, click inside the PivotTable, then choose PivotTable Analyze > Insert Slicer, select one or more fields, and click OK. The slicer appears as a clickable panel of buttons that filters the PivotTable without requiring you to open a field’s drop-down menu.
What a PivotTable slicer does
A slicer is a visual filter for a PivotTable. Each button represents a value from a chosen field—for example, a region, product category, salesperson, or year. Clicking a value filters the report to show matching records; the PivotTable recalculates to reflect the selection. A slicer can make a report easier to explore because its available choices stay visible on the worksheet.
For example, imagine a sales PivotTable with Region in the rows, Product in the columns, and total Revenue in the values. Add a slicer for Year, and clicking “2025” filters the report to that year. Add another for Product, and a reader can select a product as well. The slicers work together: the report shows records that meet both selections.
A slicer is not a separate chart or copy of the data. It controls filtering on a PivotTable, and it can also control a PivotChart linked to that report. It does not alter the source records; it changes which records the PivotTable includes in its summary.
Check the PivotTable before inserting one
Make sure the active cell is inside the PivotTable. The PivotTable Analyze tab is contextual, so it appears in the ribbon when a PivotTable is selected. If you do not see it, click a cell in the report rather than the surrounding worksheet. A slicer is most useful when the selected field contains a manageable number of distinct values. A field with thousands of individual transaction IDs, for instance, can create a very large and awkward slicer.
Consider what each field represents before choosing it. Region, status, year, and product family are often useful because readers can understand the categories quickly. Fields with inconsistent entries—such as “North,” “NORTH,” and “N.” for the same region—may show those as separate choices. Clean or standardize the source data when appropriate, then refresh the PivotTable so the report reflects the corrected categories.
Insert a slicer step by step
- Click any cell in the PivotTable you want to filter.
- On the ribbon, select PivotTable Analyze > Insert Slicer.
- In the Insert Slicers dialog box, select the checkbox beside each field you want to filter by. You can choose more than one field.
- Click OK. Excel places a slicer for each selected field on the worksheet.
- Drag a slicer by its border to move it. Resize it with its sizing handles, then click one of its buttons to filter the report.
When planning a dashboard, leave enough room for the slicers and the report to remain readable. If the slicers land on top of important cells, move them to an open area or rearrange the worksheet before sharing it. A slicer is a worksheet object, so it can sit near the PivotTable without occupying a row or column in the source data.
Use selections and clear filters
Click a slicer button to show records matching that item. To select a continuous range of items, click the first item and then Shift-click the last item. To choose separate items, use the slicer’s Multi-Select control if it is displayed, or use Ctrl-click on Windows. The Multi-Select control is often the clearest option for readers who may not know the keyboard method. The selected buttons are visually distinguished from unselected ones.
To remove a slicer’s filter, click the Clear Filter icon in the slicer header. The icon typically resembles a filter with a clear or red-X mark. Clearing one slicer does not necessarily clear the selections in other slicers. For example, clearing the Region slicer leaves a Year selection in place, so the PivotTable remains filtered by year.
If a slicer item is unavailable or appears dimmed, the current selection in another connected slicer may leave no matching records. That is often expected: selecting one product category can make regions with no sales in that category unavailable. Clear or change the other selection to see whether the item becomes available.
Arrange and format slicers
Click a slicer to show its contextual Slicer tab. From there, you can choose a style and adjust options such as the number of button columns. More columns can make a tall slicer shorter, while fewer columns may be easier to scan when the choices have long labels. You can also resize the object to show more of its buttons at once; if not all choices fit, the slicer provides a scroll bar.
Use a consistent style across related slicers, and give each one a clear field heading. Short, descriptive headers help distinguish, for example, a slicer for “Order Year” from one for “Ship Year.” Avoid shrinking buttons until their labels are difficult to read. If a slicer has many categories, a field filter or a redesigned report may be more practical than forcing every option into a small dashboard panel.
Connect one slicer to multiple PivotTables
A slicer can control more than one PivotTable when those reports share a compatible data source and PivotTable cache or model. This is useful for dashboards that show several views of the same records, such as sales by region alongside sales by product. Insert the slicer for one PivotTable, select it, and choose Slicer > Report Connections (the command may be labeled PivotTable Connections in some Excel builds). Select the PivotTables you want it to control, then confirm.
If a report is missing from the connections list, it may not share the required underlying source or cache with the other report. Having similar-looking source tables is not always enough. Consider building related PivotTables from the same source or Data Model when designing the workbook, rather than assuming the slicer can link any two reports. Test each selection after connecting the reports: a shared slicer should update every checked PivotTable, not just the one where it was first inserted.
Slicers, field filters, and timelines
PivotTable field filters are useful when worksheet space is limited or when a field has too many possible values for a visible panel. They sit in the PivotTable’s row, column, or filter labels and are opened as needed. A slicer trades some worksheet space for visibility: readers can see the choices and current filter state without opening a menu. Neither method changes the source data, and both are ways to filter the report.
For date fields, a timeline may be more convenient than a standard slicer. Select the PivotTable and choose PivotTable Analyze > Insert Timeline, then select a date field. A timeline offers date-based navigation, such as viewing a year, quarter, month, or day range. It requires a suitable date field in the PivotTable source; text that merely looks like a date may not behave as a true date. Use a regular slicer instead when readers need to choose categories or when a date field is not recognized for timeline filtering.
Common slicer problems and fixes
- Insert Slicer is unavailable: Click inside the PivotTable. If the active selection is a normal cell or a chart that is not connected to a PivotTable, the PivotTable-specific command may not be available.
- New source values do not appear: Refresh the PivotTable after adding or changing source records. If the source range did not include the new rows, update the PivotTable’s data source or use a suitably structured Excel Table as the source so added rows can be included.
- A slicer shows old or unexpected categories: Refresh the PivotTable and check the source for spelling differences, blanks, or obsolete entries. Depending on the PivotTable’s settings, old items may also be retained in its field lists; review PivotTable Options if they persist after a refresh.
- The slicer affects only one report: Open its Report Connections or PivotTable Connections and check whether the other PivotTable is selected. If it is not listed, investigate whether the reports share a compatible source or cache.
- Buttons are missing or difficult to use: Enlarge the slicer, adjust its column count, or scroll within it. If the field contains an excessive number of values, choose a broader field or use the PivotTable’s field filter instead.
Refreshing matters because a slicer filters the PivotTable’s available categories, not a live view of every possible source value. After importing new rows, refresh the report and confirm that the newly added categories appear. If the workbook is shared, explain when readers should refresh and whether the source data is expected to change.
Excel for Mac and Excel for the web
In Excel for Mac, select the PivotTable and look for the contextual PivotTable ribbon tab and its slicer-insertion command; ribbon labels and placement can differ by Excel version. Slicer objects and basic filtering are available in current desktop Excel editions, but some layout and connection commands may be arranged differently. On Mac, keyboard selection conventions can also differ, so using the slicer’s on-screen Multi-Select control avoids relying on a Windows-specific key combination.
Excel for the web may expose fewer PivotTable and slicer authoring or formatting commands than the desktop app, and available features can change. If you cannot create or configure a slicer in the browser, open the workbook in desktop Excel, add or adjust the slicer there, and then save the workbook. Always confirm that the people who will use the file can interact with the slicer in their version of Excel.
Frequently Asked Questions
Can I insert a slicer for a normal Excel table?
Yes. Select a cell in an Excel Table and use the table’s contextual Table Design > Insert Slicer command when available. That slicer filters the table itself. A PivotTable slicer instead filters a PivotTable, so choose the command that matches the object you need to control.
Can one slicer filter both a PivotTable and a PivotChart?
A PivotChart is tied to its associated PivotTable, so a slicer connected to that PivotTable can filter the chart as well. If the chart does not respond, check that it is a PivotChart based on the report you are filtering, rather than a separate chart built from another range.
Why are some slicer buttons greyed out?
Another active filter may exclude those values from the current results. For example, a selected year may have no records for a particular category. Clear the other slicer or change its selection to check whether the choices become available.
How do I remove a slicer?
Click the slicer’s outer border so the object is selected, then press Delete. This removes the slicer object; it does not delete the PivotTable or its source data. If you only want to stop filtering temporarily, use the slicer’s Clear Filter control instead.
Do slicers update automatically when I add source rows?
Not necessarily. Refresh the PivotTable after the source data changes, and make sure its source range includes the added rows. A source formatted as an Excel Table can make expansion easier to manage, but the PivotTable may still need a refresh to show updated results.
When a slicer is the right choice
Use a slicer when readers should be able to see and change a small set of meaningful report filters directly on the worksheet. It is especially helpful on interactive summaries and dashboards where the current selection should be obvious. For a dense PivotTable, a field filter may take less space; for date exploration, a timeline may be clearer. Choose the control that fits the number of choices, the report layout, and the way people will use the workbook.
Related
- Embed Video in PowerPoint With HTML: Options That Work
- Free Budget Expense Tracker Spreadsheet: Excel Guide
- How to Embed a YouTube Video in PowerPoint
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Do All Merged Cells Need to Be the Same Size in Excel?No. In Excel, merged cells do not all have to be the same size: one merged area can…
- Excel File Opening Blank? Causes, Checks, and FixesIf an Excel file opens to a blank screen, first check whether the workbook or its sheets are…
- Using Solver in Excel to Find Values That Sum to a TargetTo find which numbers add up to a target in Excel, assign each number a 0-or-1 decision cell,…
- Google Sheets Formulas vs Excel: Key DifferencesGoogle Sheets and Excel use many of the same formula conventions, so everyday calculations such as sums, averages,…
- How to Protect a Sheet in Excel and Set PermissionsIn Excel for Microsoft 365 on Windows, open the worksheet, choose Review > Protect Sheet, select which actions…
- Excel Conditional Formatting RGB Colors ExplainedYes. In Excel for Microsoft 365 on Windows, you can use a custom RGB color in a conditional…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.