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
Solving Name conflict in excel
stanoh in Excel on
1 Replies
Macro to Import Information from Email Attachments into excel
calof1 in Excel on
0 Replies
i am stuck on vba and copying row based on value
tduff1460 in Excel on
1 Replies
Room Booking using Excel
Maddie1215 in Excel on
0 Replies
How to get to the last line with data in an Excel workbook?
seanp413 in Excel on
2 Replies
Excel Formula Question
BigErn1175 in Excel on
3 Replies