excel is only sorting some columns - please help

[Guest]

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

 

[Gord Dibben]

Don't let Excel guess.

Select all the columns in your data range before sorting on the address column.


Gord Dibben MS Excel MVP

 

[Guest]

I did that, it still doesn't sort the first three columns.

 

[Ron Coderre]

You may need to make your file (or a shrinky-dink version of it) available
at a free file-hosting service and post the link here. That way we'll be
able to see what your describing.

Here are some options:
http://www.flypicture.com/
http://cjoint.com/index.php
http://www.savefile.com/index.php
-------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

 

[Gord Dibben]

Could you post a few columns and rows of your data for us to peruse.

Don't post a file unless you want to use one of the Internet sites.

Use either of the 2 free filehosts below to upload a sample of your actual
worksheet.
(Desensitize it first, if needed). Then copy & paste the generated link to
your sample file in response here:

http://www.flypicture.com/
http://cjoint.com/index.php


Gord

 

[Guest]

Hi Dan,

If I understand your post correctly, I think you need to select all the
columns you need to sort, then click on "DATA", then SORT BY.........follow
the prompts. That should do the trick for you. Take care.

Ron