One line of code will do this (maybe put in your Personal.xls):

Sub Foo()
Activesheet.ShowAllData
End Sub

Then assign it to a New (Macro) Icon in your toolbar.
It will always be available on any sheet that has an autofilter
range assigned.

HTH

"derwood" wrote in message
oups.com...
i have many columns of data using the autofilter. is there a shortcut
that either returns all the fields to the all function or a shortcut
that returns all the data to the page

thanks