T
Tia
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!
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!