I cheat.

I select the row with the headers.
I hit the delete key. The data in those header cells is erased and the
autofilter arrows removed.
I hit ctrl-z to put the data back.

Be careful.

Pastel Hughes wrote:

My preference, as far as shortcuts are concerned, mostly involves toolbar
buttons.
There is one to reset all filters to "Show All".
There is one to switch the Auto Filter On,
but there appears to be no Toolbar button to switch Auto-Filter off
completely.
It would make sense to me to be able to use one button to toggle the Auto
Filter.
Is there a way of creating such a button (in VB)?

--

Dave Peterson