View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
AllYourSpam AllYourSpam is offline
external usenet poster
 
Posts: 6
Default Change the sort order of the filter

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?