I'm not sure you can change this, but if you're showing all the data for all the
columns in the filtered range, you could add a button to your favorite toolbar.

Tools|customize|commands tab|data category
Grab "Show All" and drag it to a nice location.

vishu wrote:

If you go to within filter option (In Excel 2003)<data <filter
you can see first two option sort ascending and sort discending.
In earlier version it was not there. I use to use only short cut keys to
make use of filter option. For show All option i was using Home button. But
now its go to sort ascending option. Is there any option to cancel these two
option.

--

Dave Peterson