Alternatively, use the Filter feature, it adds sorting controls to each column and maintains the integrity of the rows.


On 8/2/22, 3:41 PM, "Code for Libraries on behalf of Tim McMahon" <[log in to unmask] on behalf of [log in to unmask]> wrote:

    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