Sorting Data
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.
Sorting Order
If you think sorting order is simple and obvious, then you need more variety in your sheets. Here’s how Numbers determines sorting order:
- Numbers: It’s no surprise that numbers get VIP treatment. Data formatting is ignored, so $2 comes after 1 and before 3, while ...
Get Take Control of Numbers now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
