Sorting Columns in Excel

[Radiojoe315]

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?

 

[Rollin_Again]

Select all three columns before doing the sort (DATA --> SORT)

Regards,
Rollin

 

[Don Felipe]

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.

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?