ActiveSolutions

Q: How do I sort or reorganize while using the new Numbers 3.0

How do I sort or reorganize while using the new Numbers 3.0; I can't seem to find the sort icon.

Thanks

ActiveSolutions

MacBook Pro, OS X Mavericks (10.9)

Posted on Oct 23, 2013 5:15 AM

Close

Q: How do I sort or reorganize while using the new Numbers 3.0

  • All replies
  • Helpful answers

Page 1 of 3 last Next
  • by Jerrold Green1,

    Jerrold Green1 Jerrold Green1 Oct 23, 2013 6:29 AM in response to ActiveSolutions
    Level 7 (30,001 points)
    Oct 23, 2013 6:29 AM in response to ActiveSolutions

    Active,

     

    Sort options are still in the Column Tab drop-down menu.

     

    Jerry

  • by bretmcvey,

    bretmcvey bretmcvey Oct 23, 2013 8:35 AM in response to Jerrold Green1
    Level 1 (0 points)
    Oct 23, 2013 8:35 AM in response to Jerrold Green1

    Sort via just a single column at a time appears available, but sorting entire rows in a table doesn't appear to be present unless I'm missing some hidden feature somewhere.  I used to be able to select a series of rows and then sort via a variety of criteria that I could customize.

  • by darlenefromaz,

    darlenefromaz darlenefromaz Oct 23, 2013 9:02 AM in response to bretmcvey
    Level 1 (0 points)
    Oct 23, 2013 9:02 AM in response to bretmcvey

    I can't find it either.  I used to be able to sort just selected rows with multiple sort criteria, but can't figure out how to do that now.  It isn't possible they would have eliminated that ability, is it?

  • by chrismcveigh,

    chrismcveigh chrismcveigh Oct 23, 2013 9:15 AM in response to ActiveSolutions
    Level 1 (0 points)
    Oct 23, 2013 9:15 AM in response to ActiveSolutions

    I'm absolutely stunned by the removal of the reorganize panel. I have a number of massive spreadsheets that I need to reorganize constantly to make sense of the data, and without the reorganize panel I'm going to have to sort one column at a time.

  • by maczx,

    maczx maczx Oct 25, 2013 4:00 AM in response to chrismcveigh
    Level 1 (0 points)
    Oct 25, 2013 4:00 AM in response to chrismcveigh

    Have just sent feedback suggest others do as well as the more that grumble at the loss of what I regard as basic functionality the more likely someone will take note.

     

    I am not a happy chappy!

  • by dexstruh,

    dexstruh dexstruh Oct 25, 2013 5:34 AM in response to maczx
    Level 1 (60 points)
    Oct 25, 2013 5:34 AM in response to maczx

    I'll do the same - used that feature nearly every day.

  • by Miketheteacher,

    Miketheteacher Miketheteacher Oct 25, 2013 10:09 AM in response to ActiveSolutions
    Level 1 (0 points)
    Oct 25, 2013 10:09 AM in response to ActiveSolutions

    It seems to have been migrated and renamed as "Filter" and can be found in the top right.  It is actually quite a bit easier to use, IMO.

  • by SGIII,

    SGIII SGIII Oct 25, 2013 11:10 PM in response to bretmcvey
    Level 6 (10,710 points)
    Mac OS X
    Oct 25, 2013 11:10 PM in response to bretmcvey

    Alas, no multiple column sort in Numbers 3.0. But there is a workaround that isn't too onerous. Say you have columns A, B, and C and you want to sort by column A then by column C then by column B. Just add a new column D with the formula =A&C&B. Then sort by column D.

     

    SG

  • by HIGBerg,

    HIGBerg HIGBerg Oct 25, 2013 11:40 PM in response to ActiveSolutions
    Level 1 (0 points)
    Oct 25, 2013 11:40 PM in response to ActiveSolutions

    It seems like the option to organize based on categories in a column with summation of each category is gone too. Or has anyone found it?

    Hans

  • by maczx,

    maczx maczx Oct 26, 2013 5:45 AM in response to HIGBerg
    Level 1 (0 points)
    Oct 26, 2013 5:45 AM in response to HIGBerg

    Can I suggest  .... if there is functionality missing in Numbers 3.0 that users miss (like the reorganising and sorting functions mentioned above) besides submitting feedback might be a good idea to submit a product rating/review via the App Store.

  • by Jerrold Green1,

    Jerrold Green1 Jerrold Green1 Oct 26, 2013 5:56 AM in response to maczx
    Level 7 (30,001 points)
    Oct 26, 2013 5:56 AM in response to maczx

    Maczx,

     

    I've read that highly critical reviews have been deleted, so be objective and not too incendiary.

     

    Jerry

  • by cleitonPena,

    cleitonPena cleitonPena Oct 26, 2013 6:00 PM in response to SGIII
    Level 1 (0 points)
    Oct 26, 2013 6:00 PM in response to SGIII

    The problem are not sort in the Columns, but sort "selected rows", that could be done in earlier version of Numbers through the window Organize. And I think the new Filter option not replaced the previous version Organize. The Filter not replaced the Organize. I agree with @darlenefromaz and @HIGBerg: the Organize is gone... and we need to ask for apple resurrect him.

  • by SGIII,

    SGIII SGIII Oct 26, 2013 6:15 PM in response to cleitonPena
    Level 6 (10,710 points)
    Mac OS X
    Oct 26, 2013 6:15 PM in response to cleitonPena

    Yes, I understand the convenience of the old Reorganize panel. I thought it was great. The problem is (I'm guessing) that it is really hard to do something like that in Numbers iOS and Numbers for iCloud. So they gave us features that are more likely to work across all platforms.

     

    If you need to sort just selected rows you could put the =A&C&B formula (or whatever order you need) in just the rows you need to sort. Leave the other cells in column D blank.

     

    Or, if you're doing a LOT of partial sorting like that maybe you should have the data in separate tables anyway.

     

    Not saying it's great... just saying there are workarounds... until (if) something like the Reorganize panel comes back by popular acclaim. 

     

    SG

  • by EZEVANS,

    EZEVANS EZEVANS Oct 29, 2013 9:58 AM in response to ActiveSolutions
    Level 1 (0 points)
    Oct 29, 2013 9:58 AM in response to ActiveSolutions

    This is most disturbing. I need the sorting functionality. filtering on the new Numbers does not work in the same way as sorting at all. it wont show anything but the filtered items.

Page 1 of 3 last Next