Alphabetizing An Excel Spreadsheet

No Comments

Today’s Technology Tip is a practical use for Excel that any teacher could appreciate: How to alphabetize a list of names in excel.

Even if you have a list of names in Word or another Microsoft program you might be able to copy and paste them into excel and then follow these directions to alphabetize them.

1) Highlight all the data you want to alphabetize. Don’t forget all the attached cells. For example if you
have an address list and only highlight the names and not the addresses the names will be alphabetized and the addresses won’t move. For your information, I did highlight the top row (the Header Row). The
computer might recognize it as a Header Row or it might not. In step three we’ll have a chance to tell the
computer that the top row is a Header Row and shouldn’t be alphabetized.

2) Next, go to “Data” on the menu bar and select “Sort” from the list:

3) Next we want to make sure the computer knows that the top row is a Header Row and doesn’t
need to be alphabetized with the other rows. If your top row isn’t a Header Row select “No Header Row” Then we want to select the column heading to sort by. In this example we want to sort by “LastName” in “Ascending” order.

4) Just click “OK” and your list should be automatically sorted for you.

Of course you could sort by any heading. For example if your holiday card list was really long and you could qualify for bulk rate postage (more than 500 pieces I believe) you would want to sort your addresses by Zip Code excelfor the post office.

March 2021
S M T W T F S
 123456
78910111213
14151617181920
21222324252627
28293031  
 
 

More from our blog

See all posts

Keyboard shortcuts you’re not using

Every time you lift your hand off the keyboard and reach for…
Continue reading

Tips for working from Home

Many of us are working from home and have been for some…
Continue reading

Some more Keyboard tips

Those of us who spend hours a day on the computer may…
Continue reading

There’s an app for that!!

You can access useful apps on the Google Play Store (Android users) and the App…
Continue reading

Some tech tips for using a Tablet

Tablets Computer tablets are very convenient and are very similar to your…
Continue reading

Some more Tips for Smartphones

It is very hard nowadays to have a cell phone that is…
Continue reading

Tips Especially for Tablet Users

Everyone, nowadays, seems to have a tablet, whether IPad or Android. I've…
Continue reading

How to take better Mobile Phone Pictures

Smartphone cameras have only gotten more phenomenal in the past three years,…
Continue reading
No Comments

Recent Posts

 

Leave a Comment