1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Sorting Columns in Excel

Discussion in 'Business Applications' started by Radiojoe315, Jul 2, 2007.

Thread Status:
Not open for further replies.
  1. Radiojoe315

    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?
     
  2. Rollin_Again

    Rollin_Again

    Joined:
    Sep 4, 2003
    Messages:
    4,912
    Select all three columns before doing the sort (DATA --> SORT)

    Regards,
    Rollin
     
  3. Don Felipe

    Don Felipe

    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.
     
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 733,556 other people just like you!

Loading...
Similar Threads - Sorting Columns Excel
  1. kitkat9716
    Replies:
    2
    Views:
    840
  2. ImaGrump
    Replies:
    1
    Views:
    452
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/591076

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice