sort - not columns - but rows in 3.01

How to sort - not columns - but rows - in 3.01?

iMac, Mac OS X (10.6.4)

Posted on Dec 21, 2013 2:49 AM

Reply
8 replies

Dec 21, 2013 3:09 AM in response to sunefromsmørum

Hi sune,


As far as I know, Numbers has always had the ability to sort rows. Numbers 3.0.1 has lost the abilty to sort only some rows within a table, but there are ways to work around this. In the meantime, we must wait for Apple to re-instate Multi-column and range sort (and other features):


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


Please reply with a description of what you are trying to do.


Regards,

Ian.


Dec 21, 2013 4:14 AM in response to sunefromsmørum

Hi Sune,


While we all wait for Apple to put this feature back in another update of Numbers 3, try this:


User uploaded file


You want to sort rows 11-14 (as an example). Add a Colour Fill to row 15 as a guide for later. 😉

Select rows 11-14. Click and *hold* on any Row Reference Tab. You will see the selected rows appear to 'lift'. Drag those rows away from Table 1 to a blank part of the 'canvas':


User uploaded file


and they will form a new table. Sort this table.

Then select all rows of Table 2, and Copy.

Click on Table 1. Select the colour filled row where you want to insert (row showing 23 Jun 2013 in this example).


Menu > Insert > Copied Rows.


User uploaded file


Not as easy as Numbers 2.3 Reorganize Panel, but a workaround.


If you frequently resort the same rows, consider placing them in their own table.


Regards,

Ian.

Dec 21, 2013 5:37 AM in response to Yellowbox

Another feature that I wish they changed for the worse was the ability to select all the rows/columns of a table and insert them into another table. You used to be able to lift rows from a table, do what you needed with them as another table, then put lift them and put them back into the original table without having to copy/"insert copied rows" or delete a leftover table. Now you cannot lift every row/column of a table so you cannot simply slide the rows back where they came from as you could in '09.

Dec 21, 2013 12:25 PM in response to Badunit

@Badunit


Can you

  • lift the rows you want to work on from the original table
  • do what you need with thes rows as another table
  • add a row or two to this 'other' table so that the lifted and worked on rows are no longer the 'whole' table
  • lift the altered rows (now only 'part' of the table)
  • put them back in the original table.
  • select what's left of the 'other' table and press delete


Not quite as convenient, but is it workable?


Regards,

Barry

Dec 21, 2013 1:23 PM in response to Barry

Barry,


First let me clarify my original statement. I don't "wish they changed for the worse". I must have typed something else first (such as "I wish they would put back in") and changed it. It should be "...they changed for the worse..."


Yes, you can add a row, put the other rows back where they belong, then delete the leftover table. That's what I've been doing but it is two extra steps that should be unnecessary. It worked better in '09.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

sort - not columns - but rows in 3.01

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.