Excel 2003 has an Excellent tool for working with database lists. It is called a data form. You can use the data form to navigate through your records, search for records, and to add or delete records.

To add a record to a list using a data form, right click on a cell in the list (so you can see the blue asterisk and a thick blue border around the list), and select Data->Form from the menu bar.

Selecting the Form option will display the form for your list.

To add a record, click the New button on the form, which will clear the text in the field boxes. Type the information for each field in the corresponding text box, (you can move between field boxes with the tab key or by a mouse click) and press Enter only when you are finished. The new record will be entered into the list at the position of the blue asterisk. The text boxes on the form will be cleared so you can enter another record if you wish.

A list and data form with a new record ready to be entered.

A list and data form just after the record has been entered.

To enter another record, just fill in the text boxes with the appropriate field information and press Enter.

Repeat this process for every record you have to add to the list.