Excel Slicers for Tables: Filter Without the Drop-Down

Stop clicking tiny filter dropdowns in your Excel tables. Here’s a better way to filter your data. With slicers, you get big, clickable buttons that filter your table fast, and you can see what’s selected at a glance. In this post, you’ll set up Excel slicers for tables, adjust the layout, and use them to drill down from region to customer to item in seconds.

Why Excel slicers for tables beat tiny filter dropdowns

Filter dropdowns work, but they slow you down when your table has lots of values. The click targets are small, the lists can feel cramped, and it’s easy to lose track of what’s filtered when you hop between columns.

Excel slicers for tables fix that by putting filters on the sheet as visual controls. Each slicer shows the available options, and when you click one, the table updates right away. Better yet, slicers work together, so one choice tightens the other lists automatically. As a result, you can explore your data like you’re turning knobs instead of opening menus.

Here’s what tends to feel better with slicers:

• Bigger targets: You click clear buttons, not tiny dropdown arrows.
• Faster scanning: You can see options in a grid, not a long list.
• Clear context: The slicers show what’s available after other filters apply.

Add slicers to a table in Excel

Pick fields for Excel slicers for tables

Start inside the table so Excel knows what data the slicers should control.

1. Select any cell within your table.
2. Go to Insert.
3. Click Slicer.
4. Check the fields you want, in this case: customer name, location, and item description.
5. Click OK.

Excel creates three different slicers, one for each field you picked. At this point, they may look crowded, so the next step is to set columns and position them where they’re easy to use.

Arrange slicers so they’re easy to click

A simple layout change makes Excel slicers for tables feel much faster because you see more options without scrolling.

1. Click the Location slicer.
2. Set it to 4 columns, then expand it out so the buttons fit.
3. Click the Customer Name slicer.
4. Set it to 4 columns as well, then move it where you want it on the sheet.
5. Click the Item Description slicer.
6. Set it to 3 columns.

After that, you have a clean grid of filters you can click without hunting through dropdown lists.

Filter faster with connected slicers

Once Excel slicers for tables are on the sheet, you can filter in plain sight and watch the other slicers react.

Filter by location, then narrow to a customer and item

Here’s one fast path that mirrors how people actually explore data.

1. In the Location slicer, select Asia.
2. Look at Customer Name. It now shows the customer names are just Save-A-Lot, Trader Joe’s, and Walmart.
3. Next, click Walmart to narrow the table again.
4. Then click apples in Item Description to filter it down even more.

Now you’re looking at Walmart, in Asia, for apples, and the table reflects only that slice of data.

Start from an item, then see who sells it

You can also filter in the opposite direction with Excel slicers for tables.

1. In Item Description, click apples.
2. Check Customer Name to see which stores sell those.
3. If you want to tighten it more, add a location selection next.

Because slicers are connected, each click updates what’s possible in the other slicers, so you don’t waste time selecting options that don’t apply.

Another example: Audi by country

The same idea works for any item and region combo.

1. In Item Description, select Audi.
2. Notice it shows they’re sold in Germany and the US.
3. In Location, click Germany to focus the view.

Clear filters and remove slicers safely

Slicers make it easy to filter, and they also make it easy to get back to a full table view.

Clear slicer selections

To reset Excel slicers for tables, use the built-in clear control on each slicer.

1. On a slicer, click Clear Filter.
2. Repeat on the other slicers until the full dataset returns.

Remove a slicer without leaving the table filtered

If you plan to delete a slicer, clear it first so your data returns to normal.

1. First, click Clear Filter on the slicer you want to remove so it puts your data back.
2. Right-click the slicer.
3. Click Remove Item Description (or the matching remove option for that slicer).

After you clear the rest of your filters, all of your data is restored.

Conclusion

Excel slicers for tables replace tiny dropdown clicks with clear, on-sheet controls that update together. Set them up once, then filter by location, customer, and item with a few taps. Most importantly, use Clear Filter before you remove a slicer so the table returns to a full view. Follow along for more Microsoft Excel and Microsoft 365 tutorials.

Get Started with Microsoft 365

Be sure to subscribe to my YouTube Channel for more Microsoft Excel and Microsoft 365 Tutorials.

This page may contain affiliate links. These are tools I personally use and love. I may receive a small commission should you make a purchase using one of these links. This helps keep the tutorials and website posts coming and up to date. Thank you for your support! For more information please see my full disclaimer.