SELECT A TOPIC

Excel 2000
Working with Databases
Sorting a database

Sorting a database

A database is a list or table of information, consisting of Column Labels (data categories — e.g. name, address, age) and Records (information unique to each person or item in the database).

To sort a database using multiple criteria, choose Sort from the Data menu; otherwise, use the sorting icons below:


To sort a list in ascending order (A to Z): select a cell in the target column, then click the icon shown left.

To sort a list in descending order (Z to A): select a cell in the target column, then click the icon shown left.