ACCC Seminars

Welcome
Import Files
Databases
One-Input Tables
Scenarios
LOOKUP Function
Linking Files
Related Links

Handout (PDF)
ACCC Seminars
Rev. Sep 21/2000

Excel 2000 Intermediate


 

Sorting Records in an Excel Database

When you click on any cell in a list, Excel can recognize the list and sort it based on which column you click. The Sort Ascending and Sort Descending buttons can then be used to sort the records any way you wish. As a rule, numbers are sorted ahead of text if the column in question is mixed. <Click here> to see a video demo of sorting. (435K)

If you want more control over the sort or sort by multiple columns, you can use the Data|Sort menu to different kinds of sorts.

Back to TopImporting Files into Excel Importing Files into Excel AutoFilter One-Input Tables
   

Seminar materials: <http://www.accc.uic.edu/seminars/excel2000-intermed>
Last Modified: September 21, 2000 — pjm