Deselct all auto-filters at once?

G

gill.webster

I have a sheet with lots of columns where I might have filtered on
several at the same time. Is there a quick way to reset them all back
to "(all)" at once or do I have to trust that I have checked each one
of the columns & not missed any?

Much obliged,

Gill
 
D

Don Guillett

If you want a macro
Sub showall()
On Error GoTo away
ActiveSheet.ShowAllData
away:
End Sub
 
D

Dave Peterson

I've added a ShowAll button to my customized toolbar.

Tools|customize|toolbars tab (to create a new toolbar if you need to)
tools|customize|commands tab|data category
drag Show All to that toolbar

I've also dragged the autofilter icon right next to show all.
 
Top