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 >