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.