Excel Slicer Video: How to Add, Use, and Troubleshoot

How-to basics · Updated November 21, 2026

If you’re looking for an Excel slicer video, search Microsoft’s Excel help and training resources for slicer tutorials; a useful demonstration should show how to insert a slicer, filter a table or PivotTable, and clear the filter. In Excel for Microsoft 365 on Windows, select a table and choose Table Design > Insert Slicer, or click a PivotTable and choose PivotTable Analyze > Insert Slicer, then select the fields you want to filter.

What an Excel slicer video should show

A good video makes clear which kind of data object is being filtered. Slicers work with Excel tables and PivotTables, but the insertion steps differ slightly. They are visual controls made of clickable buttons: instead of opening a column’s filter menu, you can click a category such as West, January, or Outdoor to filter the connected data.

When choosing a tutorial, look for one that identifies its Excel version and starts with a small, understandable dataset. It should show what happens when you select one item, select several items, and clear the selection. If the video demonstrates PivotTables, it is also useful for it to explain refreshes and how to connect a slicer to more than one compatible PivotTable. A tutorial that only shows colors and button styles may leave out the steps that matter most.

Microsoft’s menus can change slightly between desktop and web versions, so match the instructions to the Excel version you use. The steps below are for Excel for Microsoft 365 on Windows. Excel for Mac and Excel for the web can have different ribbon layouts or feature availability; if a command is missing, check the relevant version’s Insert or table/PivotTable ribbon rather than assuming the workbook is damaged.

What slicers do and why people use them

A slicer is a visible filter for a table or PivotTable. Each button represents an item in a field, such as a department, product, region, or year. Selecting a button filters the connected object to show matching records or summaries. Selecting multiple items usually includes records matching any of those items within that slicer. Selections in different slicers combine: a Region slicer set to West and a Product slicer set to Chairs show data meeting both conditions.

Slicers are useful in reports and dashboards because the current selection is easy to see. A conventional filter can be less obvious to someone opening a workbook, particularly if they do not know which column has been filtered. A slicer also gives readers a large, direct target to click. It does not change or delete the underlying records; it filters what the connected table or PivotTable displays.

For example, imagine a sales table with Date, Region, Product, and Amount columns. A Region slicer can let a reader show West sales, while a Product slicer narrows those results to Chairs. A PivotTable built from that data can then summarize the filtered sales by month. The slicer controls the view; it does not replace the source data or calculate a new definition of sales.

How to insert a slicer in Excel

For a formatted Excel table in Microsoft 365 on Windows, click a cell inside the table before using the ribbon. For a PivotTable, click inside the PivotTable. Then follow the appropriate steps:

  1. For a table: Choose Table Design > Insert Slicer. If Table Design is not visible, first click a cell in the table.
  2. For a PivotTable: Choose PivotTable Analyze > Insert Slicer.
  3. In the dialog, select one or more column or field names, such as Region and Product, and choose OK.
  4. Move the slicer near the report it controls. Click a button to filter the results.
  5. To remove the slicer’s current selection, use the clear-filter icon in its header. In a slicer with multiple items selected, the multi-select control in the header can help change how selections are made.

You can select multiple buttons in a slicer. In the Windows desktop app, use the slicer’s multi-select control or hold Ctrl while clicking additional items. If you click a single item after making a multi-item selection, Excel may replace the existing selection with the new one. The clear-filter icon returns that slicer to showing all items; it does not clear selections in other slicers.

A slicer can take up room, so begin with only the fields that make the report easier to explore. Adding every column as a slicer can clutter a worksheet and make it harder for readers to find the important controls.

Table slicers and PivotTable slicers compared

A slicer attached to an Excel table filters the table’s rows. This is a straightforward option when the report is a list of records and the reader needs to show a subset. The table must be a real Excel table, not merely a range with colored formatting. If necessary, select the range and use Insert > Table to turn it into one before adding a slicer.

A PivotTable slicer filters the PivotTable’s summary. This is helpful when readers need to explore totals, counts, or other PivotTable results by category. A PivotTable can also be connected to a PivotChart, so the chart responds to the same filtering choices. Slicers generally offer a more visual alternative to filtering from the PivotTable field drop-downs, but they do not create the summary themselves; the PivotTable still needs suitable fields in its rows, columns, values, or filters.

Do not assume that one slicer automatically controls every object on a worksheet. A table slicer is associated with its table. A PivotTable slicer may be shared with other PivotTables when those PivotTables are compatible, commonly because they share the same source or PivotTable cache. For a slicer connected to a PivotTable, select it and look for Slicer > Report Connections, sometimes labeled PivotTable Connections. The available list shows which PivotTables Excel can connect.

Connect, arrange, and format slicers

When a report contains multiple compatible PivotTables, a shared slicer can make them respond together. Select the slicer, open Report Connections or PivotTable Connections, and check the PivotTables it should control. If a desired PivotTable is absent from the list, it may not share a compatible source or cache. The connection dialog cannot make unrelated PivotTables compatible by itself.

To improve readability, select a slicer and use the Slicer tab to adjust its appearance and layout. Depending on the selected object and Excel build, options include a style, button height and width, and the number of columns of buttons. More columns can reduce the slicer’s height, but narrow buttons may cut off long labels. Resize it so the full choices are easy to read, and place it close to the report it filters.

Give the controls clear labels through nearby worksheet text if the field name alone is not obvious. For example, a heading such as Choose a region can explain a Region slicer to a first-time reader. If the workbook will be printed, check how the slicer and report fit on the printed page; an on-screen dashboard layout may not fit well on paper.

Common slicer problems and fixes

  • Insert Slicer is unavailable: Click inside the table or PivotTable first. A plain cell range is not enough for the table-slicer command; convert the range to an Excel table if appropriate.
  • A slicer shows the wrong or incomplete choices: Check the source column and the current filter state. If source records have changed, refresh the PivotTable. New or renamed source items may not appear as expected until the PivotTable updates.
  • One PivotTable responds but another does not: Use Report Connections or PivotTable Connections to check the slicer’s links. If the second PivotTable is not offered, investigate whether the two PivotTables use compatible sources or caches.
  • Clicking a button seems to show no data: Another slicer or filter may be restricting the results at the same time. Clear the slicers one at a time and inspect the other filters before concluding that records are missing.
  • Old items remain visible: A PivotTable may retain items from its source history, or the source data may still contain those values. Refresh the PivotTable and review its data source and field settings.
  • The slicer is hard to use: Widen the buttons, increase the number of columns, or make the slicer larger. Long category names and many items can make a compact slicer difficult to scan.

Remember that a slicer is not a substitute for checking the data. A filtered report can look complete while other filters are active. Before sharing an analysis, clear filters or label the current selections so readers know which records the displayed totals represent.

Slicers, ordinary filters, and timelines

Column filter menus are compact and practical when a worksheet has many fields or when only the workbook’s author needs to filter it. Slicers are more visible and easier to operate in a dashboard, but they consume worksheet space. Both approaches filter data rather than rewriting it. A slicer is especially useful when the people using a report may not know where to find a column’s filter menu.

A Timeline is a related visual control for filtering date fields in a PivotTable. It presents dates along a time scale and can make it easier to select a period such as a month, quarter, or year. It is not simply another name for a slicer, and it is not the same as a slicer for a text category. Use a regular slicer for fields such as Region or Product and consider a Timeline when the PivotTable’s date field and Excel version support it.

Slicers do not directly filter arbitrary formula results or every chart on a sheet. A chart responds when it is based on a connected PivotTable or on data that changes as a result of the filtered table. If a chart does not change, check what data the chart uses and whether its source is actually controlled by the slicer.

Frequently Asked Questions

Where can I find an Excel slicer video?
Search Microsoft’s Excel help and training resources or a video platform for Excel slicer tutorials. Look for a demonstration that names its Excel version and shows both inserting a slicer and clearing or changing its filter.

Can I add a slicer to a normal range?
Not directly as a table slicer. Convert the range to an Excel table with Insert > Table, then click inside the table and choose Table Design > Insert Slicer. PivotTable slicers are inserted from a selected PivotTable.

How do I clear a slicer filter?
Click the clear-filter icon in the slicer header. This resets that slicer to include all its items; other slicers and filters remain as they are.

Can one slicer control two PivotTables?
Often, if the PivotTables are compatible. Select the slicer and open Report Connections or PivotTable Connections to choose the PivotTables it should affect. If a PivotTable is not listed, the two may not share a compatible source or cache.

Does a slicer delete hidden rows?
No. A slicer filters the connected table or PivotTable; it does not delete the underlying records. Clear the filter to display the items again, assuming the source data is still present.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.