Filter Shortcut

[Guest]

Is there a ctl, shift, alt shortcut to turning the filter selection to "all"?
Instead of using the mouse or move to the cell that has the header that has
the filter turned on. alt+down arrow, home key, enter?

 

[Don Guillett]

Here is a macro I use and have assigned to a button. You can assign a hot
key.

Sub showall()
On Error GoTo away
ActiveSheet.ShowAllData
away:
End Sub

 

[Dave Peterson]

I've added a "show All" button to my favorite toolbar.

Tools|customize|commands tab|Data category
(near the top in xl2003)

In fact, I added the funnel like icon that applies Data|Filter|autofilter right
next to that "show all" icon.

===
And the way I remove the data|filter|autofilter:

I select that row with the arrows.
I hit the delete key.
The contents of all the cells in that row is erased.
I hit ctrl-z to bring back the contents, but the arrows are gone.

(I find that quicker than Data|filter|and unchecking autofilter--more of a
keyboarder than a mouser!)