Auto-filter not grabbing all the data

J

JerseyJ

Hi...I'm trying to filter through a database that has over 15,000 rows and
not all the data is showing up in the filter. It seems to stop somewhere
between 13321 and 13401. I've read through all the threads here and everyone
is saying that the Auto-filter drop-down list is the only thing limited to
10,000 items but that it should filter the whole spreadsheet. Apparently not.
Can anyone help, please?? Thanks....
 
D

Dave Peterson

I never let excel guess at the range that should be filtered. I'll always
explicitly select my range.

If your data has empty cells in it, then excel may not guess right.
 
J

JerseyJ

Thanks, Dave. That did help. Once I went to select my own range, I also had
to have a mini-lesson in their weird interpretation of criteria setting.
Haha. But I got it to filter all 16,000 rows correctly. Thanks again Dave!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top