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

Chapter 10. Analyzing Worksheet Data > Adding Records Using a Data Form

Adding Records Using a Data Form

A Data Form provides an optional method of entering information in a list. Once field names are entered, you can access a Data Form using the Data menu. You don't even need to select the list range first; as long as the active cell is somewhere within the list range when the Data Form is opened, Excel will automatically locate the list. As you add new records to the form, the list range is constantly updated with the new rows, and Excel automatically enlarges the list range to include them.

Add to a List Using a Data Form

Click any cell within the list range. If you have not entered any records for the list yet, click one of the field names.

Click the Data menu, and then click Form.

Click New.

Type each field entry in the appropriate text box.

Click in each field or press Tab to move from field to field.

Click Close.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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