1. Click on the top record cell of the column you want data sorted by. Don’t select the field label, otherwise the column title will be sorted along with the records and my not remain at the top of the database.
2. Select Data/Sort from the menu bar.
   (Note that you can apply more than one criteria from the dialogue box that appears.)

To find particular records, use the Criteria function of a data form. From the menu bar, select Data/Form, then click on the ‘Criteria’ button of the dialogue box. For effective searching you need to use Operators.

Autofilter allows the display of only selected group of records in an Excel database. For example, only those customers that have bought “grabbits”.

1. From the menu bar, select Data/Filter/AutoFilter – the option becomes ticked.
2. A drop down list button appears for each field (column title).