rickkessler
Level 1 (0 points)

Q: sorting in numbers

how do you sort specific rows in a column in Numbers 3.0.1

Posted on Jan 13, 2014 10:22 PM

Close
rickkessler

Q: sorting in numbers

  • All replies
  • Helpful answers

  • by Yellowbox,

    Yellowbox Yellowbox Jan 13, 2014 11:04 PM in response to rickkessler
    Level 6 (10,515 points)
    Mac OS X
    Jan 13, 2014 11:04 PM in response to rickkessler

    Hi Rick,

     

    This feature is lost in Numbers 3. Apple has promised to bring it back:

     

    http://support.apple.com/kb/HT6049


    • Customize toolbar
    • Improvements to zoom and window placement
    • Multi-column and range sort
    • Auto-complete text in cells
    • Page headers and footers
    • Improvements to AppleScript support

     

    Meanwhile, select the rows you want to sort:

     

    Screen Shot 2014-01-14 at 5.48.56 pm.png

     

    Click and hold on one of the selected Rows Tabs until the selection 'lifts'. Drag to an empty place on the canvas. It will form a new table. Sort.

     

    Screen Shot 2014-01-14 at 5.55.25 pm.png

     

    To get it back, there is a trick. Numbers 3 won't move a whole table into another table. Click in the last row and press enter to add another row. Select every row except the last.

     

    Screen Shot 2014-01-14 at 5.58.25 pm.png

     

    Now click and hold on one of the selected row tabs and drag back into place in the original table.

     

    With a large table, it may help to place a 'marker' row to show where to drag back to.

     

    I find click-and-hold-then-drag is easier with a mouse than a trackpad. With a trackpad, click on the lower left corner of the pad. Then struggle with dragging.

     

    Regards,

    Ian.