Sorting multiple columns as 1 list alphabetically?
 

Can anyone help with a solution for something i'm trying to achieve in
excel?

I have a long list of names that spread many cells down as well as
several columns across and i'm trying to sort the entire list into
alphabetical order. I know I can sort one column at a time but that is
not what i want to achieve. I need to be able to select all of the data
and sort it into alphabetical order (with the a's starting in the first
cell of the first column and the z's finishing in the last cell of the
last column). What I really need to do is be able to link columns so
that the data is viewed as one and then sorted.

Is there a solution to this problem? Any help would be greatly
appreciated


--
philpott
------------------------------------------------------------------------
philpott's Profile: http://www.excelforum.com/member.php...o&userid=28211
View this thread: http://www.excelforum.com/showthread...hreadid=477552

Sorting multiple columns as 1 list alphabetically?
 

It is not easy, especially with text. Check out this thread...

http://www.excelforum.com/showthread...iple +columns

Good Luck...


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=477552

Sorting multiple columns as 1 list alphabetically?
 

Thanks for your reply, but your answer is way to technical for me.
Surely there must be an easier way??


--
philpott
------------------------------------------------------------------------
philpott's Profile: http://www.excelforum.com/member.php...o&userid=28211
View this thread: http://www.excelforum.com/showthread...hreadid=477552

Sorting multiple columns as 1 list alphabetically?
 

pp,

My Excel add-in Special Sort will do that.
It has 12 sort features not found in the Excel sort utility.
The "Table" sort feature will sort a table (selection) across rows
or down columns.
It come with a two page Word.doc install/use file.
It is free upon email request. Remove XXX from my email address.

Jim Cone
San Francisco, USA


"philpott"wrote in message

Can anyone help with a solution for something i'm trying to achieve in
excel?
I have a long list of names that spread many cells down as well as
several columns across and i'm trying to sort the entire list into
alphabetical order. I know I can sort one column at a time but that is
not what i want to achieve. I need to be able to select all of the data
and sort it into alphabetical order (with the a's starting in the first
cell of the first column and the z's finishing in the last cell of the
last column). What I really need to do is be able to link columns so
that the data is viewed as one and then sorted.

Is there a solution to this problem? Any help would be greatly
appreciated
--
philpott

Sorting multiple columns as 1 list alphabetically?
 

That email address is...
XX