Auto Filter not showing all data

[Guest]

When using auto filter on a spreadsheet that has over 1005 lines of data the
auto filter will not list any data after line 1005. What can I do to have it
list all the data?
I have a spreadsheet of names with their phone numbers that goes to line 1044.

 

[Ron de Bruin]

Hi dcknie

See
http://www.contextures.com/xlautofilter02.html#Limits

 

[Guest]

Thanks for the help. I will set just have to set up the formula.

 

[Ron de Bruin]

You can also use EasyFilter if you want
http://www.rondebruin.nl/easyfilter.htm

 

[Guest]

It is NOT protected. It was shared, but I "un-shared" it.

 

[Gord Dibben]

You may have a blank row at that spot but more likely.........

The autofilter dropdown list will show only 1000 items by default.

Workarounds are to use Custom and "equals" or "contains" or similar.

See also Debra Dalgleish's site for methods.

http://www.contextures.on.ca/xlautofilter02.html#Limits


Gord Dibben MS Excel MVP