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 Lists and Other Ranges

Excel provides numerous ways to sort worksheet ranges. You can sort by columns or rows, in ascending or descending order, and with capitalization considered or ignored. (When you sort by rows, the rows of your list are rearranged, and the columns remain in the same order. When you sort by columns, 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.

Sorting on a Single Column

To sort on a single column—the Last Name column in Figure 28-1, for example—select one cell anywhere within that column. Then click either the Sort Ascending button on the Standard ...

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