Select your range, then Auto Filter, don't let Excel guess your range.


"Kim" wrote:

I am using excel 2007 and my auto filter is not working. There is no drop
down box for "blanks" or any of the items except for "select all". Any ideas?