+ Reply to Thread
Results 1 to 4 of 4

Alphabetical columns

  1. #1
    faustrocket
    Guest

    Alphabetical columns

    I would like to arrange a mailing list in alphabetical order. Is it possible?
    How? The list has already been typed so retyping it is not an option.

  2. #2
    Forum Contributor
    Join Date
    01-06-2004
    Location
    Carbondale CO
    Posts
    245
    faustrocket,
    Highlight the range (column or columns)you want to sort and
    go to DATA>SORT on the Menu bar (usually at the top)

    Also, I there is an abundance of information by typing "sorting" or "sort" into help.

    HTH
    Casey

  3. #3
    Gord Dibben
    Guest

    Re: Alphabetical columns

    Retyping is ALWAYS an option<g>

    Show us a sample of your data and perhaps we can help.

    Are all components of the address in one cell or spread across several?

    Where are the names listed?

    What do you want alphabetized? Names, streets, cities, states?


    Gord Dibben Excel MVP

    On Thu, 6 Oct 2005 15:48:05 -0700, "faustrocket"
    <faustrocket@discussions.microsoft.com> wrote:

    >I would like to arrange a mailing list in alphabetical order. Is it possible?
    >How? The list has already been typed so retyping it is not an option.



  4. #4
    David McRitchie
    Guest

    Re: Alphabetical columns

    Hi "faustrocket",
    You can sort your list.
    1) select all cells Ctrl+A, but in Excel 2003 use Ctrl+Shift+SpaceBar instead
    as Ctrl+A was botched up (hope the change back in the next version).
    2) Then use Data, Sort the rest should be clear. One important thing
    to note is whether your columns have a header row or not.

    http://www.mvps.org/dmcritchie/excel/sorting.htm

    Since you have not sorted before, suggest you create a copy of your worksheet
    and check out the results afterwards that phone numbers, and addresses still
    reside with the correct name.

    By selecting all cells (all cell on all columns on all rows), your associated data
    will move along with the sorted fields. Failure to make a selection i.e. a single
    cell may work in some cases but not in others. Excel will expand to the current
    region which stops at an empty column (and at an empty row), which would leave
    some of your data outside of the included area and really mess you up if you ever
    try to rely on using Current Region in Excel. Excel 2003 changed Ctrl+A to be
    the same as Ctrl+SHIFT+* which is the current region, and will guarantee
    destruction sooner or later of the integrity of your data.
    http://www.mvps.org/dmcritchie/excel...x2k.htm#foobar
    ---
    HTH,
    David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
    My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
    Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

    "faustrocket" <faustrocket@discussions.microsoft.com> wrote in message news:01081395-3BBC-41AD-A494-7F95B44F1D2E@microsoft.com...
    > I would like to arrange a mailing list in alphabetical order. Is it possible?
    > How? The list has already been typed so retyping it is not an option.




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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