+ Reply to Thread
Results 1 to 4 of 4

Excel 2007 : Sorting Columns so that all data moves around together

  1. #1
    Registered User
    Join Date
    09-23-2009
    Location
    Houston, TX
    MS-Off Ver
    Excel 2003
    Posts
    2

    Question Sorting Columns so that all data moves around together

    So it's been about 9 years since ive had to play with excess to any extent, much less the asthetically new 2007 version...essentially, here is my questions:

    I have 3 collumns- NAMES(A), EMAILS(B), and PHONE#'s(C)


    This is a running list that i need to be able to input new contacts into later, then resort alphabetically.
    How can i lock the emails and phone contacts together to stay with the names when resorted alphabetically? i assume grouping?
    Any help would be greatly appreciated.
    Last edited by NBVC; 09-24-2009 at 02:49 PM.

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Making Contacting list and making EMAIL/PHONE# list restrained to NAME collumn

    Make sure you don't select just column A when sorting...

    select any cell within the range of occupied cells and then sort by column A...

    that should work.
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Registered User
    Join Date
    09-23-2009
    Location
    Houston, TX
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Making Contacting list and making EMAIL/PHONE# list restrained to NAME collumn

    Thanks for the help! being pretty well versed in the computer world (Cisco background) i was banging my head EXTRA hard on the desk. lol. It really has been YEARS since i've touched excel. feel free to delete this thread..i'm not sure if anyone would have quite the simplified problem i had...

  4. #4
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: Making Contacting list and making EMAIL/PHONE# list restrained to NAME collumn

    Believe it or not, this question and much simpler solution questions come up quite often.. this is one of the reasons we want to try to make titles of threads more accurately reflect the question... so that the forum is more searchable and you don't need to ask... just find a similar solution and apply

    So, we'll keep it and maybe adjust the title... and if you can please mark as Solved... Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1