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" <CODE4LIB_at_LISTS.CLIR.ORG on behalf of tmcmahon_at_WLPL.ORG> 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
Received on Wed Aug 03 2022 - 12:42:29 EDT