Log In
Register
Home
November 15, 2021
Offline
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? 
July 16, 2010
Offline
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
November 15, 2021
Offline
Thanks Mynda,
Fantastic... knew there'd be a way.
Incredibly helpful as usual - find your YouTube Dashboard tutorials very inspirational.
Ian
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
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.
1 Guest(s)
