Macros

Hello Ann-Marie

Thank you for your question.

You can clear all autofilter settings by going to Data - Filter and selecting Clear All.

If you wish to have a toolbar button to do this, go to Tools - Customise, then select the Commands tab. Select Data from under Categories on the left, then on the right find the Show All command. Drag and drop the Show All command onto a toolbar, where you want the button positioned, then click Close.

I hope you find this useful.
Amanda