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