Deleting a Record from the Data List

Unless it's already open on your desktop, choose Data, Form to open the data list form for the data list you created in the task “Entering Worksheet Data Using a Form.”

Follow the steps in the task “Searching for a Data List Record” to find the record you want to delete.

Click the Delete button in the data list form to permanently remove the record from the data list.

Excel warns you that the record will be permanently deleted from the data list. If you don't want to delete the record, click Cancel; otherwise click OK.