Table Filter/ Sory Reset Button Needed

[Rhall6310]

I have a table comprised of an inventory 4,207 individual commercial furniture line items.

Line Item Example:
Type of Furniture Manufacturer Model/Style Size Finish Condition Building Location Code Future Location Bar Code
Task Chairs Allsteel Task Mesh Back / Dark Red Poor Main main1st1 4207

It is being used to assist in inventory searches across three buildings and hundreds of rooms within the buildings.

I am using the Filter and Sort option supported in the header info of the table.

For Example when I want to find all the Task Chairs made by Allsteel in the main building - I adjust the filters and get the report I need. Very clean and simple.

WHAT I NEED - is a reset button that puts all the filter criteria back into "Select All" mode so we do not have to manually go back a reset every filter option we selected to the Select All positionExisting Furniture MEG Final.xlsx.

Is there a way to accomplish this?

Any help is appreciated - we have just started to use this table of inventory and people are not resetting the filters and getting bad reports.
Would be happy to forward the table.
Thanks Rhall

[PeteABC123]

CTRL+SHIFT+L to remove filters..
Repeat to add the filter dropdowns back. You might have to re-select your table range before using the key combination to insure that you're capturing all the column data. If it's a clean continuous table it shoudln't be a prolbem..

HTH.

Pete

[Rhall6310]

Thanks - Really appreciate your help.