Data forms provide a simple method for entering data into an Excel list. By opening a data form, Excel creates a dialog box on-the-fly, based on your list's column headings. When you enter data in the form, Excel fills in the correct columns, adding rows to the end of the list, if necessary.
Tip
Although you can also use data forms to view and search for information in lists, this technique is rarely worth it. Sorts, filters, and PivotTables are much easier ways to browse a list. The advantage of using a data form for data entry is that Excel automatically adds each row you enter to the end of the list without requiring you to reposition the active cell.