Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Auto Filter
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Auto Filter
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. "Jamie R" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Auto Filter
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. "Franz Erhart" wrote: 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. "Jamie R" wrote: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Auto Filter
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. "Jamie R" wrote: 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. "Franz Erhart" wrote: 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. "Jamie R" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DataFilterAuto Filter in excel 2007? | New Users to Excel | |||
Excel 2007 Auto Filter Filter | Excel Discussion (Misc queries) | |||
Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
Auto-Filter in Excel | Excel Discussion (Misc queries) | |||
Auto filter in Excel | Excel Worksheet Functions |