Last updated on November 9th, 2026 at 01:40 pm
You can insert a slicer in Excel without a pivot table by formatting your data as an Excel table first. Click any cell in the data, press Ctrl + T, then go to Table Design > Insert Slicer, tick the columns you want to filter by and click OK. Each slicer is a set of buttons that filters the table with one click. This works in Excel for Microsoft 365, Excel 2013 and later on Windows, Excel 2016 and later on Mac, and Excel for the web.

Convert the data to a table
- Click any cell inside your data. It should have one header row and no blank rows or columns.
- Press Ctrl + T, or go to Insert > Table.
- Check that the range is right and that My table has headers is ticked.
- Click OK.
The data gets banded rows and filter arrows. If you’d rather keep the plain look, choose Table Design > Table Styles > None. The slicer still works. Other table options are explained in creating a table in Excel.
Insert the slicer
- Click any cell in the table.
- Go to Table Design > Insert Slicer. You can also use Insert > Slicer.
- Tick one or more columns, such as Region and Product.
- Click OK. One slicer box appears for each column.
Filter with the slicer
- Click a button to show only matching rows.
- Hold Ctrl and click to select several items, or click the Multi-Select button in the slicer header and click items to toggle them.
- Click and drag across buttons to select a run of items.
- Click the Clear Filter button (funnel with a red x) in the slicer header, or press Alt + C with the slicer selected, to show everything again.
Several slicers on the same table work together. Choosing “East” in Region and “Laptops” in Product shows only East laptop rows.
Format and arrange slicers
Click a slicer to open the Slicer tab (called Slicer Options in some versions):
| Setting | Where | What it does |
|---|---|---|
| Slicer Styles | Slicer tab | Colors for selected and unselected buttons |
| Columns | Slicer tab > Buttons | Lays buttons out in 2 or more columns to save space |
| Height and Width | Slicer tab > Size | Resizes the slicer box |
| Caption | Slicer Settings | Changes the title shown at the top |
| Hide items with no data | Slicer Settings | Removes buttons that match no rows |
| Sort order | Slicer Settings | A to Z, Z to A or a custom list |
Use Slicer > Align to line up several slicers neatly. To stop slicers moving when you insert columns, right-click, choose Size and Properties, and set Don’t move or size with cells.
Show totals that follow the slicer
Normal SUM formulas include hidden rows. To total only the rows the slicer shows, use SUBTOTAL or the table’s Total Row:
- Turn on Table Design > Total Row, then pick Sum, Count or Average from the drop-down in the total cell.
- Or use
=SUBTOTAL(109,Table1[Sales])anywhere on the sheet. 109 sums visible rows only. Use 103 to count them.
Slicers vs filter arrows vs pivot tables
| Slicer on a table | Filter arrows | Pivot table + slicer | |
|---|---|---|---|
| Shows which filter is active | Yes, at a glance | Only an icon on the arrow | Yes |
| Summarizes data | No, filters rows | No | Yes |
| One slicer controls several reports | No | No | Yes, with Report Connections |
| Timeline for dates | No | No | Yes |
If you need summaries, or one slicer that controls several reports, use a pivot table instead. Start by making a pivot table in Excel, then edit the pivot table as your report changes. Unlike a slicer on a table, a pivot table won’t show edits to its source data until you refresh the pivot table.
Can a slicer filter two tables at once?
No. A table slicer only connects to its own table. For several tables, load them into the Data Model and build pivot tables, which can share a slicer.
Insert Slicer greyed out or not filtering
Insert Slicer is greyed out
The data isn’t a table yet, the selected cell is outside the table, or the file is in Compatibility Mode (.xls). Click inside the table, or save the file as .xlsx.
The slicer stopped filtering
The table may have been converted back to a range, which disconnects the slicer. Delete the slicer, convert the data to a table again and insert a new one.
Slicers don’t work on a protected sheet
When you protect the sheet with Review > Protect Sheet, tick Use AutoFilter and Edit objects so people can still click the slicers.

Matt Jacobs writes and maintains the guides on Support Your Tech, which he started in 2017. He spent most of his career keeping small-business PCs running and still takes the occasional consulting job, so the steps here come from fixing the same problems on other people’s computers. Every guide is checked on his own Windows 11, Windows 10, Mac, iPhone and iPad before it goes up.