An AutoFilter dropdown list will only show 1000 entries. If your first
blank cells are too far down in the list, they won't be displayed in the
dropdown list.

To AutoFilter for an item that doesn't appear in the dropdown list, you
can choose Custom from the dropdown list, and type the criteria. Also,
there are a couple of workarounds he

http://www.contextures.com/xlautofilter02.html#Limits

tamee wrote:
I have a master database that I build by pasting smaller databases into it
and now contains over 4,000+ rows. Every so often I'd like to check if there
are empty rows included by filtering and selecting the "(Blanks)" option at
the bottom of the pull-down filter menu on the specific column. I'm just
surprised that when my data exceeds 2,700+ the options (Blanks) and
(Non-blanks) are no longer displayed at the bottom of the pull-down menu even
if the (Blanks) and (Non-Blanks) option appear on the other columns'
pull-down list. Although I could use the customize option, I'm beginning to
think that there might be a problem with the file. In addition, sometimes
data at the bottom of the database don't appear in the pull-down menu.
Please help and hope someone can explain why this happens so I can prevent
this in the future.
Thanks!!!


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html