PC Doctor November 20, 2015
Have your computer questions answered here! Search the PC Doctor archive or submit a question of your own at firstname.lastname@example.org
Dear PC Doctor:
I’m writing you again about my Excel mailing list spreadsheet: New people are always becoming members of our group and I have to add them to the list. I usually figure out where their names fit alphabetically, add a row, and type them in that way. Someone told me they though I ought to be able to just type all new group members’ information in the next lines at the bottom, and then make the program alphabetize them for me. Can I do this? How?
Yes. This is one of the nice features of Excel. To get you entries alphabetized after you’ve added new ones, follow these steps:
Open your Excel file. Highlight the column you want alphabetized by clicking in the column header. The column should become shaded a different color. Over on the right of your screen, choose “Sort and Filter.” From the drop down menu, choose “Sort A to Z.” A “Sort Warning” dialog box will open. Choose to “Expand the Selection” which will keep all the data in the rows together. Click “Sort.” Your table will now be sorted, A to Z!
Until next time, Happy Computing.