5 Replies Latest reply: Mar 22, 2012 3:05 PM by Wayne Contello
r.panda Level 1 Level 1 (0 points)

I just need to sort a simple column of names in alphabetical order.  There has to be a way to do this right/


Numbers
  • Jerrold Green1 Level 7 Level 7 (29,850 points)

    See page 64 of the Numbers User Guide: Sorting Rows in a Table. You can download the user guide from the Help menu.

     

    Jerry

  • Taneria Level 1 Level 1 (0 points)

    I did that also looked at several other posts on this site when I pull up the reorganize window the ONLY options that show up are ascending or descending which is USELESS, there are no other options listed for alphabetical or by date or anything else I needScreen Grab.jpg

  • Wayne Contello Level 6 Level 6 (14,805 points)

    Taneria,

     

    I am not sure why sort ascedning or descending is useless.  What other ways can you sort?  Then you sort alphbetical you are sorting ascending if you sort A > Z, but you are sorting descending if you sort Z > A.

     

    I suggest converting the 1st row of your table to a header by clicking the contextual menu for the row and selecting "Convert to Header Row"

     

    Screen Shot 2012-03-22 at 3.00.08 PM.png

     

    Then you should be able to change the sort by more than 1 column where the column selector is more meaningful.

    Screen Shot 2012-03-22 at 3.04.17 PM.png

     

    If you are not really wanting to sort but, instead, filter.... you can use the "Show rows that match the following" by selecting the Choose a column, then check the box

  • Taneria Level 1 Level 1 (0 points)

    And from the realm of wanting to throw my computer through the window.  When I selected ascending descending before it did not arrange things alphabetically now it is.  >< sorry for the bother

  • Wayne Contello Level 6 Level 6 (14,805 points)

    In your image you had "sort selected rows" and no selected rows.  Do you have rows selected now?  Or did you change the popup menu to "Sort entire table"?