Editing records in the data form - MS-Excel Tutorial
Editing records in the data form
The Criteria data form makes it easy to locate the records that need editing in your data list. After you've displayed the data form for a record that needs editing, you can then make the editing changes by selecting the text boxes of the effected fields and making your changes, just as you would edit the entry in its cell in the worksheet.
To complete the editing changes you make to a record, you can click the New, Find Next, Criteria, or Close button (when you don't need to do any more editing to the records in the data list).