O'Reilly logo

Take Control of Numbers by Sharon Zardetto

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required