My esteemed listmates,



Any Excel experts in the list?



I created an Excel spreadsheet in Excel 365 in Windows 10.



1st column is the person’s last name, 2nd column is the person’s first name
and the there are 5 separate columns with different data associated with
each respective person in those 5 columns.



I thought I could highlight all the data in all 5 columns and select Data >
Sort and then choose A-Z it sorts all the names listed by last name in
alphabetical order but that doesn’t work.



How should I proceed to sort so the person’s last name (say A is listed
first) and the person with the name beginning with the letter W is listed
last without screwing up the pertinent info associated with that person’s
other date in the 5 other columns?



Thank you.


Charles.