filter not working

[Kim]

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?

 

[Teethless mama]

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

 

[Kim]

Teethless mama - you are "the bomb". That worked. Thanks.