Sorting LISTs


G

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!
 
Ad

Advertisements

B

Bryan Hessey

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

Advertisements

G

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top