Filter question

[juliejg1]

I have a spreadsheet with ~20,000 lines (using Excel 2003). I use a filter
on the data to quickly access what I need. I added ~30 lines of data to the
bottom of the spreadsheet. I took the filter off and then re-added it but
the new lines do not show in the drop down on the filter. I also tried
selecting all the lines before putting filter on but the new lines still
didn't show....any suggestions?

 

[Daniel.C]

No blank lines ?
Daniel

 

[juliejg1]

No blank lines ?
Daniel



No none

 

[Roger Govier]

Hi Julie

Filter has a limit of 1000 UNIQUE items for its display.
Do the extra 30 lines take you beyond 1000 of the same value in your filter
column?
There are some suggestions here on how to overcome the limit
http://www.contextures.com/xlautofilter02.html#Limits

 

[juliejg1]

Thank you ... that must be the problem as there are over 1000 unique lines of
data. I will try the website you list.