filter issue

[afdmello]

I am working on a list that is filtered all of a sudden the down arrow is
frozen and only the filter criteria is displayed. How do I enable the
dropdown list of the filter displaying all the entities.

Similarly, I have filled some cells in a column with a color can I filter to
display only these cells.

Afd

 

[Dave Peterson]

I'd remove the autofilter, then select the entire range and reapply the
autofilter.

You can filter by color in xl2007.

Or you could use Ron de Bruin's addin:
http://www.rondebruin.nl/easyfilter.htm