Share this Page URL

Part 8. Working with Data Lists > Removing a Data List Filter - Pg. 201

Working with Data Lists 201 INTRODUCTION You might not always want to display all records in a large data list. Instead, you might want to work with just a set of records--for example, all sales representatives in Region 3. When you want to work with a subset of records, you can filter the data in a data list. All the records remain in the data list worksheet, but only those meeting the criteria you select are displayed. TIP Redisplaying all records To display all records again, choose Data, Filter, Show All. Alternatively, click the arrow with the different filter color and select All from the drop-down list. Removing a Data List Filter