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

Chapter 17. Setting Up and Establishing ... > Working with the Data Form

Working with the Data Form

People who work with Excel on a regular basis usually are comfortable with the row-and-column structure and have no difficulty entering list data directly into the appropriate cells. However, the ongoing data entry and maintenance of a list might be handled by someone who is less familiar with Excel. For those users—and even experienced Excel users who prefer a simpler data-entry method—Excel provides the data form. The data form works like a dialog box; it floats over the worksheet and includes buttons and other form controls to enable the user to enter one record at a time into the list.

You also can use the data form to search for specific records in the list, using specified criteria, or even to delete records. Filters (covered in Chapter 18, “Using Excel's Data-Management Features”) are more effective when searching for information, but if your list is long and you're searching for a specific element, the data form does a good job of finding that particular record of information.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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