Hi,
Is there a way to quickly remove all filters in an Excel Table?
Using a Table there doesn't appear to be a way to remove header filters like there is if not using a Table.
Is there a straightforward way to remove all filter options from a Table without using VBA? 
Hi Ian,
Welcome to our forum!
You can use the Clear Filters button on the Data tab of the ribbon. I've even added this icon to my Quick Access Toolbar because I use it a lot!
Mynda
Thanks Mynda,
Fantastic... knew there'd be a way.
Incredibly helpful as usual - find your YouTube Dashboard tutorials very inspirational.
Ian
Is there a way to quickly remove all filters in an Excel Table?
Hi Ian,
Late reply, but I think will be useful:
Press Ctrl+Shift+L keys TWICE.
First time this key combination is pressed will hide column filters and will also remove them. Second time is just to display column filters back.
