Highlight the column you want to sort on. Excel will ask if you want to
expand you selection. Select expand and sort. If you have a header row
that you don't want to include in the sort, use the custom sort and
check 'My data has headers'.
On 8/2/22 4:58 PM, charles meyer wrote:
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.
--
*Tim McMahon*
West Liberty Public Library
