Special Edition Using Microsoft® Office XP

Using Forms to Add and Edit List Data

Data forms provide a simple method for entering data into an Excel list. When you open 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 from

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 that you enter to the end of ...