Skip navigation

numbers, sorting

209 Views 2 Replies Latest reply: May 10, 2013 12:19 AM by Barry RSS
Stormtrooper3059 Calculating status...
Currently Being Moderated
May 9, 2013 1:15 PM

How to place text in alphabetical order in a numbers spreadsheet colunm?

MacBook, iOS 5
  • Wayne Contello Level 6 Level 6 (12,650 points)
    Currently Being Moderated
    May 9, 2013 1:54 PM (in response to Stormtrooper3059)

    select the table you want to sort, then select the menu item "Table > Show Reorganize Panel"

     

    then select the column to use for the sort and whether it is ascending or descending

    Screen Shot 2013-05-09 at 3.54.01 PM.png

  • Barry Level 7 Level 7 (29,095 points)
    Currently Being Moderated
    May 10, 2013 12:19 AM (in response to Stormtrooper3059)

    Note that Numbers will not sort a single column in a multi column Table.

     

    Numbers adopts a database model, and considers all of the infomation is one row to be part of a single 'record' or set. Any sort of the table will sort complete rows, based on the data in one or more columns.

     

    If you want to sort only the words (or other data) in a single column, you will need to either remove the data to a different table (with no other data), Sort it there, then paste the result back into the original column, OR separate the column from the rest of the table, do the sort, then reinsert the column into the tble.

     

    Regards,

    Barry

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.