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