Sorting Columns in Excel

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Radiojoe315

Thread Starter
Joined
Sep 26, 2006
Messages
33
I need to sort columns in Microsoft excel but here is my dilemma I am having. I need them to be sorted based on the first column alphabetically. Which I understand requires just hitting the sort button.

However.. my grid looks something like this

NAME Hours Address
Tom 6 10 B Street
Bob 3 30 Smith Lane


I want to sort by Name alphabetically. But I want the addresses and hours to also sort along with it. So for example when Tom's name is moved below Bob's I want his hours and Address to also move with it. So everything stays organized. How would I do that?
 
Joined
Jul 1, 2007
Messages
30

Hi Radiojoe,

I work with Excel on a daily basis, formatting databases for mailing labels. Sometimes working on several thousand names and addresses at a time. I have to eliminate duplicates, which is done alphabetically. Then I sort by address, as sometimes two or more names have the same address. Lastly, I sort by zip code and state, ready for printing as a "mail merge" in Word.

Excel makes all of this very easy!

To sort in ANY order, first click the box at the top left corner of the worksheet. (It's to the left of column A, and above line number 1) This will highlight the entire page.

Then, on the toolbar, select DATA...SORT. A box will open with choices. If you have named headers; i.e. NAME, HOURS, ADDRESS, check "HEADER ROW". Then make your selections in the "Sort by", Then by" drop down lines above.

Click OK, and you're good to go!

Hope this helps.
Radiojoe315 said:
I need to sort columns in Microsoft excel but here is my dilemma I am having. I need them to be sorted based on the first column alphabetically. Which I understand requires just hitting the sort button.

However.. my grid looks something like this

NAME Hours Address
Tom 6 10 B Street
Bob 3 30 Smith Lane


I want to sort by Name alphabetically. But I want the addresses and hours to also sort along with it. So for example when Tom's name is moved below Bob's I want his hours and Address to also move with it. So everything stays organized. How would I do that?
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

No members online now.
Top