Results 1 to 5 of 5
  1. #1
    5 Star Lounger ibe98765's Avatar
    Join Date
    Aug 2001
    Location
    Bay Area, California, USA
    Posts
    966
    Thanks
    19
    Thanked 4 Times in 4 Posts
    Using Excel 2007

    Say I have data like this (each numeric is in one cell):

    1, 5, 9, 13, 11
    1, 23, 14, 5, 6
    24, 12, 1, 31, 40
    etc.

    I want to sort each rows values so they look like this on completion:
    1, 5, 9, 11, 13
    1, 5, 6, 14, 23
    1, 12, 24, 31, 40

    The Excel help seems to indicate that I should be able to do this:




    Sort rows
    1. Select a row of data in a range of cells, or make sure that the active cell is in a table column.
    2. On the Data tab, in the Sort & Filter group, click Sort. [img]/global/images/default.aspx?AssetID=ZA101654081033[/img]

      The Sort dialog box is displayed.
    3. Click Options.
    4. In the Sort Options dialog box, under Orientation, click Sort left to right, and then click OK.
    5. Under Column, in the Sort by box, select the row that you want to sort.
    6. Do one of the following: By value
      1. Under Sort On, select Values.
      2. Under Order, do one of the following:
        • For text values, select A to Z or Z to A.
        • For number values, select Smallest to Largest or Largest to Smallest.
        • For date or time values, select Oldest to Newest or Newest to Oldest.
    By cell color, font color, or cell icon

    1. Under Sort On, select Cell Color, Font Color, or Cell Icon.
    2. Click the arrow next to the button, and then select a cell color, font color, or cell icon.
    3. Under Order, select On Left or On Right.
    [*]To reapply a sort after you change the data, click a cell in the range or table, and then on the Data tab, in the Sort & Filter group, click Reapply. Note When you sort rows that are part of a worksheet outline, Excel sorts the highest-level groups (level 1) so that the detail rows or columns stay together, even if the detail rows or columns are hidden.

    I tried following these directions. However, I don't see as choices:

    • For number values, select Smallest to Largest or Largest to Smallest.
    • For date or time values, select Oldest to Newest or Newest to Oldest.

    So I tried creating a new list with numbers that ranged from 1 to 50.

    I then selected one row and tried to sort the cells in it, but it doesn't do anything (nothing changes).

    Can anyone help with this problem? Is it really possible to sort individual row cells?

  2. #2
    2 Star Lounger
    Join Date
    Jan 2007
    Location
    Gray, Louisiana, USA
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I tried as well, it looks like you have to have the numbers in a column in order to sort them manually as the HELP instructions suggest.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2007
    Location
    Gray, Louisiana, USA
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I spoke too soon it can be done.

    Highlight the numbers to sort then click sort, then options, left to right
    Attached Images Attached Images

  4. #4
    5 Star Lounger ibe98765's Avatar
    Join Date
    Aug 2001
    Location
    Bay Area, California, USA
    Posts
    966
    Thanks
    19
    Thanked 4 Times in 4 Posts
    Quote Originally Posted by stans View Post
    I spoke too soon it can be done.

    Highlight the numbers to sort then click sort, then options, left to right
    Yes. I got that far before. But playing around today, I was able to get one row sorted at a time.

    However, it does not appear possible for Excel to sort multiple cells IN multiple rows natively!

    Maybe there is some VBA function that could do this? Something that would step through each row in a table and do the single row sort each time?

  5. #5
    5 Star Lounger ibe98765's Avatar
    Join Date
    Aug 2001
    Location
    Bay Area, California, USA
    Posts
    966
    Thanks
    19
    Thanked 4 Times in 4 Posts
    OK, I found someone else with this problem and a macro solution here:

    http://en.allexperts.com/q/Excel-105...ows-follow.htm

    Works just fine.

    Of course, it would have been easier if Microsoft had included this functionality in Excel itself. Excel has been around for what 20 years or so? And I am sure that many people have requested this functionality...

Posting Permissions

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