O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

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 Items

If you sort field items using the standard Sort command, Excel will sort all instances of your field items and preserve the sort order when you pivot the table. For example, to generate a descending sort of the Channel items as shown in Figure 30-15, you could select cell B6, choose Data, Sort, and specify a descending sort. Excel would then present the Channel items in the order Mail Order, International, Domestic in every place where those items occur.

You can also sort field items using an AutoSort feature. Like the standard Sort command, AutoSort rearranges table material across all instances and preserves the order you want even when you move fields from axis to axis. However, the AutoSort feature gives you the additional option ...

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