Filter option

G

Guest

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.
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot See Sort Ascending/Descding option in drop down filter 1
auto filter problems 2
2003 Filter and Sort Ascending 1
autofilter sort not visible 1
VBA- Excel Programming:- 0
Sorting while protected - this question may not have been covered. 1
ProtectSheet Options are un-checking after macro 9
Excel 2003 - turn off option in autofilter 1

Top