L
lifeworksla
Hello,
I have a database of contact info we need to use for a mass mailing. I'm
trying to sort it by address so I can delete the entries that we don't have
addresses for. However, when I select a cell in the "Address" column and hit
the sort button, it doesn't sort the first three colums, so the data is all
messed up. I can tell this is the case because the first three columns stay
the same, while the rest of the columns are sorted according to address.
I tried using smart filters and the same thing happens. I tried selecting
all columns and the same thing happens. If I choose a cell in one of the
first three columns then it will sort all data including those columns, but
if its the 4th 5th 6th etc column then the first three are ignored and not
sorted.
If anyone knows how I can get Excel to sort ALL the data that would be a
great help. Thanks!
Dan
I have a database of contact info we need to use for a mass mailing. I'm
trying to sort it by address so I can delete the entries that we don't have
addresses for. However, when I select a cell in the "Address" column and hit
the sort button, it doesn't sort the first three colums, so the data is all
messed up. I can tell this is the case because the first three columns stay
the same, while the rest of the columns are sorted according to address.
I tried using smart filters and the same thing happens. I tried selecting
all columns and the same thing happens. If I choose a cell in one of the
first three columns then it will sort all data including those columns, but
if its the 4th 5th 6th etc column then the first three are ignored and not
sorted.
If anyone knows how I can get Excel to sort ALL the data that would be a
great help. Thanks!
Dan