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.

Hi dcknie

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



--
Regards Ron de Bruin
http://www.rondebruin.nl


"dcknie" wrote in message ...
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.

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

"dcknie" wrote:

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.

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



--
Regards Ron de Bruin
http://www.rondebruin.nl


"dcknie" wrote in message ...
Thanks for the help. I will set just have to set up the formula.

"dcknie" wrote:

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.

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

"dcknie" wrote:

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.

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

On Tue, 13 Nov 2007 13:23:02 -0800, Julieeeee
wrote:

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

"dcknie" wrote:

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.