W
willyhoops.com
the autofilter is for drilling down into your data by selecting a smaller
range. for some reason the default autofilter in excel 2007 instead shows a
bunch of options at the top including even "sort by colour" and it's main
purpose, selcting a sub range has been depreciated and made more difficult to
use. it now takes many more clicks to select a range... dates get divided
into years, months and days with check boxes on all of them. you have to
uncheck "select all" before you do anything. is there anyway to have a
sensible autofilter like in excel 2003 or are we stuck with this dreadful
interface forever? my beautiful excel is ruined
range. for some reason the default autofilter in excel 2007 instead shows a
bunch of options at the top including even "sort by colour" and it's main
purpose, selcting a sub range has been depreciated and made more difficult to
use. it now takes many more clicks to select a range... dates get divided
into years, months and days with check boxes on all of them. you have to
uncheck "select all" before you do anything. is there anyway to have a
sensible autofilter like in excel 2003 or are we stuck with this dreadful
interface forever? my beautiful excel is ruined