Elise has attended:
Excel Intermediate course
Filters
Is there a way of getting rid of all filters on a large worksheet. If so, is there a keyboard function?
RE: Filters
Hi Elise
Thank you for your question. You can clear filters by going to the Data menu then Filters > Show all.
I have found a keyboard equivalent too.
Tap the Alt key (then let go) follwed by D then F and finally S
This will drop the filter criteria whilst leaving auto filter enabled.
I hope this helps - do let me know if you have any further questions.
Kind regards,
Andrew