Tim,

Worked perfectly except that it then places the named column as an entry in
the rows.

Ex. 1st Column is Last Names 2nd Column is First Name 3rd Column is Story
Name Third Column is email address 4th colum is phone # etc.

What happens is it alphabetizes all the name and other columenbspoerflect
byu places Last Name - First Name - Email - Phone number as titles  on the
top of each column across on Row 18?? Weird.

Thanks so much.

Charles.


Date:    Tue, 2 Aug 2022 17:41:39 -0500
From:    Tim McMahon <[log in to unmask]>
Subject: Re: Excel sorting

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'.