View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Tyro[_2_] Tyro[_2_] is offline
external usenet poster
 
Posts: 1,091
Default Change the sort order of the filter

I apply a filter to the dates. Then I sort the filtered list as newest to
oldest. Works fine.

Tyro

"AllYourSpam" wrote in message
...
Working in 07, I have a column of years that ranges back over 100 years
that
is filtered. Is there a way to have the FILTER show in reverse order?
Doesn't
matter if I sort the colunm A-Z or Z-A, the filter always shows oldest
year
first and we mostly work with the more recent so we have to scroll to the
bottom of a very long filter almost every time. Can that be changed?