How to get intended result, issue with clear-filter not working correctly/as expected in tables.

New Contributor

Excel issue with clear-filter not working correctly/as expected in tables (listobject?)

Did insert table  on sheet, filled table , apply two filters, clear one, result is not as expected, 

Have to clear all filters first, then re-enter filtering-criteria for correct 'expected result'.


Way to complicated to understand, way to much re-entering filtering-criteria. 

How to get intended result with less effort.


Step 1Apply filter Fruit on Product-type
Step 2Apply filter Mango on Product
Step 3 Clear filter from Product-type
Step 4Select column Product, select Reapply




4 Replies

Hi @ArnoldH99 


instead of using the regular filter dropdowns, you could use slicers. They do not only work with pivot tables, but also with formatted tables. Just click in your formatted table and then choose menu "Insert | Slicer", then just pick the desired fields.

It's way easier to handle and also more transparent which filters are currently applied.



Thanks for pointing me to the slicer functionality. 

Really have to get used to this way of filtering. 

Run into another inconvenience.

Have a table(s) with many rows, and many columns, slicer windows/popups block my view.

Have Freeze Panes  on for headers.

Putting slicers in top row makes the filter view selection disappear when scrolling.

Putting slicers NOT in top row makes the filter view selection move out of sight when scrolling.

It works, don't know yet if it is going to help me better.

Yes it solves the issue , not showing the expected results.

Working with it I think I will spending a lot of time moving the slicers out of the way to see the data.

Could use a 'hide slicers' and 'show slicers' . is that available?

best response confirmed by ArnoldH99 (New Contributor)

Hi @ArnoldH99 


yes, it's really worth to have a closer look at slicers, because they are much more user friendly then regular filters.

There are also some options to customize them, so you could arrange them also horizontally by specifying the number of columns that you want to have in a row:


So if you reserve a few rows above you table and also freeze the panes to keep the header row visible, you should have always access to the slicers.


There is even a way to hide/unhide them. Just activate the selection pane (menu "Home | Find & Select |  Selection Pane...").

This pane will not only show slicers, but any other objects like charts or shapes. By clicking on the little eye-icon you can hide or unhide the object:



Thanks again, now it is getting useful, changing to new ways of working only becomes relevant when ease of use is shown/proved, you helped me with that very well.
Didn't find any reference to the use of slicers when looking for alternatives/options for my filter-options/issues. Consider myself as reasonable good finder (:-)).