Once was able to filter by color but option is no longer available on the drop down menu
I ichirus Apr 5, 2010 #1 Once was able to filter by color but option is no longer available on the drop down menu
D David Biddulph Apr 5, 2010 #2 Such an ability isn't built in to Excel. If you did it in the past, it must have been through some add-in or UDF.
Such an ability isn't built in to Excel. If you did it in the past, it must have been through some add-in or UDF.
D Dave Peterson Apr 5, 2010 #3 Are you using xl2007? Maybe you used xl2007 at work/home and a previous version at home/work??? Or maybe you used Ron de Bruin's easyfilter addin? http://www.rondebruin.nl/easyfilter.htm
Are you using xl2007? Maybe you used xl2007 at work/home and a previous version at home/work??? Or maybe you used Ron de Bruin's easyfilter addin? http://www.rondebruin.nl/easyfilter.htm
G Gord Dibben Apr 6, 2010 #4 Excel 2007 has it built-in David. Both sort by color and filter by color. Gord
D David Biddulph Apr 6, 2010 #5 Well, that emphasises how much I've got to learn about 2007. Thanks for the enlightenment, Gord.
