O'Reilly logo

Special Edition Using Microsoft® Office XP by Woody Leonhard, Ed Bott

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

Excel's sorting capabilities let you view data in almost any order, regardless of the order in which you entered it. To quickly sort a list, first click a single cell in the column by which you want to sort, and then click the Sort Ascending button. Excel selects all the data in your list and sorts it alphabetically, using the column that contains the active cell. Click the Sort Descending button to sort in reverse order, using the same column. If you want to sort only a portion of the list, make a selection first, and then use the Tab key to move the active cell to the correct column. This option, used incorrectly, can make a mess of your database, so use it with caution.

Tip from

If the order in which you enter data is important, ...

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