Mar 03 2019 03:20 PM
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.
https://www.youtube.com/watch?v=OlLCuclgf3A
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
Mar 03 2019 03:49 PM
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 :)
Mar 24 2019 05:02 PM
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.