Excel Auto Filter

  • Thread starter Thread starter Jamie R
  • Start date Start date
J

Jamie R

The worksheet I am working on has over 2000 lines. I am having a problem
where the autofilter does not show all of my data. The drop down box does not
show all the different names I have in that specific column. I have tried
having them sorted in ascending order and all. The rows that contain that
information do not show on the drop down list.
 
Hi Jamie,
I was able to duplicate your problem on my machine.
It has to do with the fact that some excel functions don't like it if there
are blank lines.
Check your data and remove blank lines, or sort them in a way the blank
lines are at the end of your 2000 lines.
This should do the trick.
 
The sheet does not have blank lines. All of the columns data in them. It does
at this time have 2280 lines with data. This will increase every week.
 
My understanding is that the dropdown list in autofilter is limited to 1000
records, so if you have more than 1000 different names in your list, you
can't view them all.
 

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

Similar Threads

Auto-filter selection 1
2003 Filter and Sort Ascending 1
auto filter problems 2
Filtered drop down list 2
Auto filter drop down box 1
AutoFilter issues 4
Auto show data but without using Auto Filter 1
Auto filter 2

Back
Top