excel 2004 data filter doesn't sort entire list

mary86004

macrumors member
Original poster
Apr 16, 2011
48
0
I am filtering a mailing list of 4709 addresses. I selected a cell in the column that I want to filter, went to data and then filter. I clicked custom filter and gave a city I wanted it to filter by. It only filtered the fist 3483 entries on the list. Then it left a blank line and the entries up to 4709 were unfiltered. Why is it doing this? How can I get it to filter the whole list?

I have done the same thing in other excel documents that were mailing lists and it filters the whole list.

Thank you so much for any help you can give me.
 

mary86004

macrumors member
Original poster
Apr 16, 2011
48
0
I mean Filter, not sort

Have you tried to manually select the entire list? Then use the Data>Sort feature to select sort columns.

Thanks for your quick reply.

First of all I typed Sort and I meant Filter. I don't think it matters to your reply.

I am not quite sure what you mean. I selected the entire page so it was highlighted then went to Data and then filter. It still only sorted the first 3483.
Then I highlighted the column I was filtering and then went to Data and filter and it still did not do the whole list.

Is this what you meant?

I want to get my mailing out and am thinking I could cut the mailing list in half and do it as two chunks and see what would happen. Still I wish I knew the right way.

Also I selected the entire document and copied and pasted the text into a new worksheet hoping it would not carry forward the problem to a new document but it only filtered the first 3484 again.
 

iSaint

macrumors 603
Try to manually select only the part of the sheet where the data is. Start in the uppermost left cell, then scroll (or goto) the lowermost right cell, press SHIFT (not control) then click on that cell. It should highlight the entire selection of data.

Sometimes trying the simple method of selecting the entire sheet or one cell doesn't work.

It should be the same for filter or sort.

Is there a piece of data missing on row 3484 that might cause it to believe it's the end?
 
Last edited:

mary86004

macrumors member
Original poster
Apr 16, 2011
48
0
solved! yea!

I looked for something missing like you suggested. Not in line 3484 but about 4 rows down there was a blank row. I deleted it. Now it is filtering the entire list. Thank you so much for the help! What a relief. I spent 5 hours trying to figure it out yesterday and ...

never mind. Thank you so much. Your advice was perfect.