Ok, I have a large spreadsheet that is organized by areas. I want to sort only one area of the sheet. I go to the sheet select sort, highlight the area I want to sort select sort specific rows and then designate the column to sort by then “sort now” and nothing happens! What am I leaving out?
iPad Air, iPadOS 26
> What am I leaving out?
You're leaving out that you're trying to run Numbers like Excel. They are not the same.
While the model in Excel uses a monolithic sheet, Numbers opts for discrete tables, so you should look to separate the 'areas' into separate tables.
Numbers applies sorting table-wide, so once your areas are separated, you're free to sort and filter the various tables independently.
> What am I leaving out?
You're leaving out that you're trying to run Numbers like Excel. They are not the same.
While the model in Excel uses a monolithic sheet, Numbers opts for discrete tables, so you should look to separate the 'areas' into separate tables.
Numbers applies sorting table-wide, so once your areas are separated, you're free to sort and filter the various tables independently.
Finally figured out that I had to cut and paste the area I wanted to sort. Sort it then copy it back in place sorted! I miss the old 123!
Hi Mike,
You can sort selected rows.
Regards,
Ian.
Sorting specific areas of a spreadsheet
