Microsoft® Excel® 2010 Inside Out

Sorting Tables and Other Ranges

Excel provides numerous ways to sort worksheet ranges. You can use the same techniques to sort both tables and ranges that you have not defined as tables. (We’ll call the latter lists.)

You can sort by column or row, in ascending or descending order, and with capitalization considered or ignored. (When you sort by row, your rows are rearranged, and the columns remain in the same order. When you sort by column, the opposite kind of rearrangement occurs.) You can even define custom sorting sequences so that, for example, your company’s division names always appear in a particular order, regardless of their alphabetic sequence. Excel 2010 can sort by as many fields as you want, not just the three-at-a-time limit of ...