autofilter question

J

jim

hi...

I have a spreadsheet with about a dozen columns and a couple thousand
rows. No empty rows or columns. When I attempt to use autofilter on
one of the columns, it only displays about two thirds of the data that
I know is there. Can anyone offer any suggestions as to why this might
occur?

TIA

Jim
 
D

Dave Peterson

If you're using xl2003 or below, then the list under the dropdown arrow is
limited to 1000 unique entries.

So that could be the trouble.

(If you're using xl2007+, then that limit is 10,000 (if I recall correctly).)

But another problem could be that you let excel guess at the range to filter.
If your data contains any empty rows, then excel will see this as a delimiter
and not include those rows under that first empty row.

If this is the case, you should remove the filter and then select the entire
range that should be filtered -- then reapply the filter.
 
J

jim

If you're using xl2003 or below, then the list under the dropdown arrow is
limited to 1000 unique entries.

So that could be the trouble.

(If you're using xl2007+, then that limit is 10,000 (if I recall correctly).)

But another problem could be that you let excel guess at the range to filter.
If your data contains any empty rows, then excel will see this as a delimiter
and not include those rows under that first empty row.

If this is the case, you should remove the filter and then select the entire
range that should be filtered -- then reapply the filter.

Thank you, Dave - it was indeed the 2003 version. I didn't know about
that limitation.
 

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