Excel sorting

From: charles meyer <reachmeplace_at_nyob>
Date: Tue, 2 Aug 2022 17:58:30 -0400
To: CODE4LIB_at_LISTS.CLIR.ORG
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.
Received on Tue Aug 02 2022 - 17:43:52 EDT