unfliter data in excel 2018 table

New Contributor

I want to create advance filter for a table by using advanced filter so that when I type some name it filters out that data from the range of cells.

I saw a video in the you tube which explains how to do it.


One of the steps advised is to unfliter the data by going in to the data tab. I have excel 2019 I suppose where I couldn't do it. I also clicked clear filter but the arrow which points down in the header does not go away

can some one help on this


Tutorial for Excel 2013 to create an advanced filter and then adds macros to run and clear the filter and attaches them to buttons
2 Replies

Does the key combination 'Ctrl+Shift+L' work for you?

It is something I use automatically following Ctrl+L to create a List/Table, to get rid of the pesky little down arrows that I never use :) 

@Peter Bartholomew 


Thanks for your reply

some how that problem is solved and I was able to successfully setup advanced filter with the tab as shown in the video.

However I have encountered another problem, up untill now I was using slicer for filtering which has stopped working.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies