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 <reachmepl...@gmail.com> 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 <tmcma...@wlpl.org> > 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'. >
