• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 23. Working with Lists and Datab... > Using Forms to Add and Edit List Dat...

Using Forms to Add and Edit List Data

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.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint