PC Doctor

Editor’s Note: Questions should be directed to the PC Doctor, care of the Athol Public Library at info@athollibrary.org or by mail at Athol Public Library, 568 Main St., Athol, MA 01331, or dropped off at the library.

******

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 thought I ought to be able to just type all new group members’ information in the next lines at the bottom, and them make the program alphabetize them for me. Can I do this? How?

Signed,

Anna

Dear Anna:

Yes. This is one of the nice features of Excel. To get your 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!

Athol Daily News

PO Box 1000
225 Exchange Street
Athol, MA 01331
Phone: (978) 249-3535

 

Comment Here