This chapter starts by looking at two background basics: the sorting order Numbers uses for letters, numbers, and blank cells; and Special Sorting Issues—how sorting interacts with headers, footers, merged cells, and hidden rows.
Next, I show you how to get Instant Sort Gratification using a table’s Column menu, and how to do more-sophisticated sorting in Sorting with the Inspector. Finally, you’ll learn how to Unsort Your Data and even Sort Unsortables.
If you think sorting order is simple and obvious, then you need more variety in your sheets. Here’s how Numbers determines sorting order: