It seems to be alphabetizing your header row of row 1.
Try first freezing the top row. (*View *tab, click *Freeze Top Row*.)
Then try the suggestion from Tim before:
"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 Wed, Aug 3, 2022 at 5:05 PM charles meyer <[log in to unmask]> wrote:

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