Sorting LISTs

[Guest]

Hi, I have a table with multiple lists. How do I sort one column and have the
rows moved with it? Selecting the entire sheet or the table greys out 'Sort'
under the Data menu.
For eg,
List1: Name, List2: Company they belong to, List3: State

How do I sort one column and have the entire row carried with it? If there
is an option to Sort by List1 first and then by List2 etc it will be great.
Is there a work around without having to unList the data?

Thanks in advance!

 

[Bryan Hessey]

Select all of the data within the Lists area, the sort is then valid for
it's usual 3 keys.

 

[Guest]

Thanks Bryan, but when i select the data within one of the Lists (selecting
data under multiple Lists greys out 'Sort'), it only sorts the data selected.
It does not move the entire row with it.