One more caveat - if your data one or more blank rows, that can prevent the
entire sheet from being included in the sort. Watch for that.

Melissa Belvadi
[log in to unmask]


On Tue, Aug 2, 2022 at 7:41 PM Tim McMahon <[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
>