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

--
Don Guillett
SalesAid Software

"Jeff Holmes" <Jeff wrote in message
...
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?