You can't change the filter dropdown, but you could add a column to the
table, and calculate the difference in years. For example, with years in
column A:

=TEXT(YEAR(TODAY())-A2,"000") & " - " &A2

Then, filter on the new column, and the most recent years will be at the
top.

AllYourSpam wrote:
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?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html