I have a spreadsheet in which I want to sort data for a specific range within it. However I cannot see where I can perform this without sorting everything else which appears in the rows outside of the range that I want to support. Help!
MacBook Air, OS X El Capitan (10.11.2)
Select the rows you want to sort. Click the Sort & Filter option in the top right. Change the Drop down to "Sort Selected Rows" instead of entire table. I have included an example. Hopefully that is what you were looking for. Good luck!
Thanks for your reply. However taking your example instead of the sorting range being a1..c whatever what if the sorting range was say c1.. f whatever BUT when I sort I need the columns a and b and columns g on to remain unchanged? I hope I have explained myself!
Bluesboy56
Hi Bluesboy,
Please post a Screen Shot of your table and tell us what you want to sort. Numbers mimics a database where each row (record) remains intact. Jay-Ray's answer is correct in answer to your original question.
To place a Screen shot here, see Wayne's User Tip:
https://discussions.apple.com/docs/DOC-6591
To sort a portion of a table, move it to another table, sort and place it back (at your peril 👿).
Regards,
Ian.
.
Numbers only allows you to sort on a by-row basis. If you want to sort only a few columns of a table, then you should
select the range you want to sort,
copy
click the canvas of the sheet (the background)
paste
sort the resulting, temporary table
select the contents of the table you just sorted,
copy
now paste that back to the original table
It seems like a lot of steps but actually can be done very quickly
Sorting a specific range of data within a spreadsheet
