O'Reilly logo

Picture Yourself Learning Microsoft® Excel® 2010 by Laurie Ulrich Fuller, Deidre Hayes, Jeffery A. Riley

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

Working with the Sort Command

WHEN YOU NEED TO GO beyond a single field sort, the Sort command (also found on the Data tab) is your ticket to multiple-field sorting. It’s also a great way to lay the groundwork for a Subtotal report, which you’ll read about in the last section of this chapter.

So why would you want to sort by more than one field? Well, sticking with the list of cities, imagine that you wanted to sort them by state and by city, so that all the cities are in state order, and within each group of states that that sort creates, the cities would be in alphabetical order. Figure 7-3 shows that sort in place.

Figure 7-3. You can sort by more than one field to put your list in a more usable order.

Using Sort ...

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