O'Reilly logo

Special Edition Using Microsoft® Office XP by Woody Leonhard, Ed Bott

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required