Excel slicer examples include filtering a sales PivotTable by region, showing only selected products in an Excel table, or letting readers choose a reporting period with a click. In Microsoft Excel for Microsoft 365 on Windows, select a PivotTable and choose PivotTable Analyze > Insert Slicer, or select a table and choose Table Design > Insert Slicer.
What an Excel slicer does
A slicer is a visual control made up of clickable buttons for filtering data. Each button represents an item from a field, such as East, West, or Central in a Region field. Selecting a button filters the associated table or PivotTable to show matching records; selecting a second button can include another item. The filtered result is visible in the worksheet, so a reader can see which choices are available and which are active.
Slicers are useful for reports that other people need to explore without opening filter menus or changing the underlying data. A slicer is not a formula and does not rewrite the source records. It changes what is displayed in its connected Excel table or PivotTable. Slicers can be moved and resized like other worksheet objects, and their buttons can be arranged in multiple columns.
A slicer needs a compatible data object. You can add one to an Excel table or a PivotTable, but you cannot attach it directly to an ordinary, unformatted range. For a regular range, first make it an Excel table or create a PivotTable from it.
A small sales example to build from
Imagine a worksheet with one record per sale and these columns: Date, Region, Salesperson, Product, Units, and Revenue. The records might include a West-region sale of a desk, an East-region sale of a lamp, and a Central-region sale of a chair. Turning that range into an Excel table or using it as the source of a PivotTable gives Excel named fields that can be used for slicers.
For a PivotTable report, put Product in Rows and Revenue in Values. The result is a summary of revenue by product. Add a Region slicer, and clicking West filters the report to West-region sales. Add a Salesperson slicer as well, and choosing a salesperson narrows the report further. The two controls work together: the visible results must meet both selections.
For a table-based report, the same Region and Product slicers filter the rows in the table itself. This is handy when someone wants to inspect individual transactions rather than a summarized total. For example, selecting West and Desk leaves only matching records visible in the table. The table’s filter drop-downs remain available too; a slicer supplements those filters rather than replacing them.
How to insert and use a slicer
- Prepare the data. Make sure each column has a header, each row is one record, and there are no blank header cells. For a table, click in the data and choose Insert > Table, then confirm whether the table has headers. For a PivotTable, select the source data and choose Insert > PivotTable.
- Add the slicer. Click inside the table and choose Table Design > Insert Slicer, or click inside the PivotTable and choose PivotTable Analyze > Insert Slicer. In the field list, select the fields you want as controls, such as Region and Product, then choose OK.
- Place and size it. Drag the slicer beside the report, and resize it so the labels are readable. For a long list, make the slicer taller; for a short list, multiple button columns can use worksheet space more efficiently.
- Filter and clear. Click a button to filter to that item. Use the slicer’s multi-select control to choose several items, if needed. To remove the slicer’s selection, use its Clear Filter icon, usually shown as a filter with a red mark.
For example, if the Product slicer has Chair, Desk, and Lamp buttons, selecting Chair shows chair records or chair totals. Selecting Chair and Desk shows both categories. A selection is not the same as choosing every item one by one: clearing the slicer returns that field to an unfiltered state.
Useful slicer examples for real reports
- Regional sales dashboard: Create a PivotTable with Region in Rows and Revenue in Values. Add a Product slicer so a reader can compare the regional totals for a particular product category.
- Team performance view: Summarize Units or Revenue by Salesperson, then add Region and Product slicers. A manager can focus on a region and product without making separate copies of the report.
- Order review table: Add a slicer for Order Status, such as Open, Shipped, or Returned, and another for Warehouse. This gives staff a quick way to narrow transaction rows to a practical subset.
- Survey results: Summarize responses by answer or rating, then add slicers for Department and Survey Period. This can help readers compare groups, provided the source data has consistent category labels.
- Inventory check: Use a table slicer for Category and Supplier. Selecting a supplier can make its product rows easier to review, while the table’s own sorting and other filters remain available.
These are report designs, not special slicer types: the field you choose determines the available buttons, and the connected object determines whether the result is summarized or shown as rows.
Connecting one slicer to multiple PivotTables
A slicer can control more than one PivotTable when those PivotTables share a compatible data source or PivotTable cache. This makes it possible to place several summaries on a dashboard and let one Region slicer filter all of them. For instance, a report might show revenue by month and units by product; a shared Region selection can keep both summaries focused on the same region.
To check the connection, select the slicer and look for Slicer > Report Connections on the ribbon. In some Excel builds or contexts, the command is labeled PivotTable Connections. Select the PivotTables the slicer should control, then confirm. If a report is missing from the list, the PivotTables may not share a compatible source or cache. Creating them from the same source does not always guarantee that an existing workbook has the needed shared connection, so check the connection dialog rather than assuming.
Table slicers and PivotTable slicers are not interchangeable connections. A slicer attached to an Excel table does not automatically filter a separate PivotTable, and a slicer connected to one PivotTable does not control an unrelated table. If the same interactive choice must control several report objects, plan the source and report structure before building the dashboard.
Selection, layout, and date controls
When a slicer has a long list of items, use its settings to make it easier to navigate. Select the slicer and use the Slicer tab options to adjust its button columns and dimensions. Slicer Settings can control such details as the displayed header and item sorting. The exact options available depend on the type of slicer and the connected object.
Multiple selection is useful when readers need to compare several regions or products at once. The multi-select button on a slicer lets the reader select more than one item without clearing the previous choice. If the buttons are too small or the field contains many distinct values, a slicer may be less convenient than a standard filter; use a short, meaningful field where possible.
For PivotTables, Excel also offers a Timeline for filtering date fields. A Timeline is a date-specific interactive control that can show periods such as years, quarters, months, or days, depending on the date field and the selected scale. It is different from a regular date slicer: use a Timeline when readers need to move across a continuous date range, and a standard slicer for categories such as Region or Status.
Slicers compared with ordinary filters
Both slicers and filter drop-downs narrow the visible data, but they serve different reporting needs. A column filter takes less worksheet space and can be practical for a user who already knows Excel. A slicer makes the active choices more obvious and is often easier for a dashboard audience to use. It also makes common selections available as large, visible buttons.
Slicers do not replace sorting, filtering, or good data design. They can take up room, become unwieldy when a field has hundreds of unique values, and make a report harder to understand if too many controls are placed together. Choose a slicer for a small set of useful categories that readers are likely to change. Keep detailed, infrequent filtering in the table or PivotTable menus.
A common misconception is that a slicer changes the source data or permanently deletes filtered-out records. It does neither: it controls which data is shown in the connected object. Clear the filter to see the full set again. If a PivotTable’s source data has changed, refresh the PivotTable separately; a slicer is not a substitute for refreshing.
Common problems and practical fixes
- Insert Slicer is unavailable: Click inside an Excel table or PivotTable first. A plain range does not provide the contextual command. If necessary, convert the range to a table or create a PivotTable.
- New items do not appear: Check that the added records are inside the table or within the PivotTable’s source range. Excel tables generally expand when data is entered directly beneath them, but a PivotTable may need its source updated and then refreshed with PivotTable Analyze > Refresh.
- A slicer does not affect another report: Select the slicer and inspect Report Connections. The other PivotTable must be compatible with the slicer’s connection. A table slicer cannot be connected to a separate PivotTable through that dialog.
- Some buttons are missing or disabled: The slicer reflects values available in its connected field and may be affected by the current filter context. Check the source column for inconsistent labels, blanks, or unexpected spelling differences, and clear other selections to see whether they are narrowing the available results.
- The report shows old totals: Refresh the PivotTable after changing its source data. If the PivotTable source is an Excel table, newly added table rows are easier to include, but the summary still needs a refresh to recalculate its displayed results.
For a workbook shared with colleagues, test the slicer after saving and reopening the file, and make sure the report explains what the controls filter. If someone needs a printed or static snapshot, remember that the page will reflect the current slicer selections, not every possible view.
Frequently Asked Questions
Can I add a slicer to a normal range in Excel?
Not directly. Convert the range to an Excel table with Insert > Table, or create a PivotTable from the range, then insert a slicer for that object.
Can one slicer control two PivotTables?
Yes, if the PivotTables have a compatible shared source or cache. Select the slicer and use Slicer > Report Connections to choose which PivotTables it controls.
How do I select more than one slicer item?
Use the slicer’s multi-select control, then click the additional buttons you want. To return to all items for that field, use the Clear Filter icon.
Why does my slicer not show newly added records?
Check that the records are included in the table or PivotTable source. For a PivotTable, update the source if needed and refresh it; the slicer cannot add source records on its own.
Is a Timeline the same as a date slicer?
No. A Timeline is a date-focused control for navigating date ranges by units such as months or quarters. A regular slicer presents date values as selectable items, which may be less convenient for a large continuous range.
Can I use slicers in Excel for Mac or Excel for the web?
Availability and ribbon placement can vary by platform and release. The steps above describe Microsoft 365 for Windows. On Mac or in Excel for the web, check the contextual Table Design or PivotTable commands for slicer options; if a needed authoring command is not available, use desktop Excel for Windows.
Related
- One-Row Data Table in Excel: How to Set Up and Use It
- One-Column Data Table in Excel: How to Create One
- One-Dimensional Data Table in Excel: How It Works
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Open Excel in a Web Browser: A Simple Step-by-Step GuideTo open Excel in a web browser, go to Microsoft365.com, sign in with a Microsoft account, and choose…
- Excel R1C1 Reference: Meaning, Examples, and SettingsIn Excel, R1C1 is a cell-reference style that identifies a cell by its row number and column number:…
- Can a Corrupted Excel File Be Fixed? Recovery StepsYes, a corrupted Excel file can often be fixed, especially if the damage is limited or a recent…
- Schedule Maker Google Sheets: Build a Practical PlannerYes. Google Sheets can work as a flexible schedule maker: create a table or calendar-style grid, add dates…
- Animate Text All at Once in PowerPoint: Step-by-StepTo animate all the text in a PowerPoint text box together, select the box, apply an animation, then…
- Shortcut Key to Insert a Line in Word: Quick GuideTo insert a horizontal line in Microsoft Word, type three hyphens (---) on a blank line and press…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.