+ Reply to Thread
Results 1 to 4 of 4

Sorting Colums into alphabetical order

  1. #1
    tox
    Guest

    Sorting Colums into alphabetical order

    I'm trying to sort 50 columns into alphabetical order. The first column
    contains a name and each column has a formula, How do I arrange the columns
    into order and make sure all the info in the columns moves with the names?

    TIA
    tox



  2. #2
    Dave Peterson
    Guest

    Re: Sorting Colums into alphabetical order

    Save first--just in case this doesn't work!

    If you select your range (last row of headers plus all the rows of details) and
    all the columns in the range you want sorted, then excel should handle it
    nicely.

    Sometimes you can get lucky and excel will guess the correct range to sort.
    I've always felt better by selecting my range first and not letting excel guess
    (right or wrong).


    tox wrote:
    >
    > I'm trying to sort 50 columns into alphabetical order. The first column
    > contains a name and each column has a formula, How do I arrange the columns
    > into order and make sure all the info in the columns moves with the names?
    >
    > TIA
    > tox


    --

    Dave Peterson

  3. #3
    Forum Contributor
    Join Date
    03-16-2004
    MS-Off Ver
    2016
    Posts
    175
    Do not choose a range and then press the ascending or descending sort button. It will only sort the range not the table.

    To sort,click on one cell in the column you want to sort. This is your key field. Now pressing the ascening sort button will sort the entire table and keep the names with the data.

    One caution. There can be no spaces in your table in either columns or rows or excel will ignore data beyond the space when it sorts.

  4. #4
    JulieD
    Guest

    Re: Sorting Colums into alphabetical order

    in addition, use Data / Sort to sort once you've selected your range, not
    the toolbar icons (BTW i only select 1 cell in my ranges rather than the
    whole range and i've never had a problem ... my ranges in this case are
    defined by a blank column & a blank row)

    Cheers
    JulieD

    "Dave Peterson" <[email protected]> wrote in message
    news:[email protected]...
    > Save first--just in case this doesn't work!
    >
    > If you select your range (last row of headers plus all the rows of
    > details) and
    > all the columns in the range you want sorted, then excel should handle it
    > nicely.
    >
    > Sometimes you can get lucky and excel will guess the correct range to
    > sort.
    > I've always felt better by selecting my range first and not letting excel
    > guess
    > (right or wrong).
    >
    >
    > tox wrote:
    >>
    >> I'm trying to sort 50 columns into alphabetical order. The first column
    >> contains a name and each column has a formula, How do I arrange the
    >> columns
    >> into order and make sure all the info in the columns moves with the
    >> names?
    >>
    >> TIA
    >> tox

    >
    > --
    >
    > Dave Peterson




+ 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