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, ...
Get Special Edition Using Microsoft® Office XP now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.