Filter option

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.
 
You must log in or register to reply here.

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
2003 Filter and Sort Ascending 1
ProtectSheet Options are un-checking after macro 9
auto filter problems 2
autofilter sort not visible 1
VBA- Excel Programming:- 0
Sort table with one click on header? 9
Using Filter more than once 2

Back
Top