Filtering a list enables you to find and work with a subset of the data in your list.Filtering displays only the rows that contain a certain value or that meet a set ofcriteria, while hiding the other rows.Exercise.
- Select any cell within your database (e.g. cell D1) and choose theAutoFilter command from the Filter submenu from the Data menu.The AutoFilter command applies drop-down arrows directly to columnlabels in the list, so you can select the item you want to display. When youselect an item from the drop-down list, Excel temporarily hides the rowsthat do not contain that item.Aston Business School Student Guide - Excel version 5.0 Database FunctionsVersion 1.0 11 December 1996To select all the records containing Dawn as a Forename:
- Click the arrow of the column containing the data you want to display, inthis case Forename. A scrolling dialogue box is then displayed.
- Select the item you want to display, in this case Dawn.Now practise using different filters.
- When you have finished, restore the database by reselecting the