Microsoft Excel Tips
and Tricks
Create Forms for Easier Data Entry
Entering large amounts of data into an Excel spreadsheet can
be very time consuming. Using data entry forms makes your
task easier. A data entry form is a dialog box that gives
you a convenient way to enter a complete row of information
at one time.
To use a data entry form to edit a list:
1.
Click a cell in the labeled row you want to add the record
to.
2.
On the Data menu, click Form.
3.
Click OK. A data entry dialog box appears, with field
labels that correspond with the column labels in your list.
To add a new record
1.
Click New.
2.
Type the information for the new record.
3.
When you finish typing data, press the ENTER key to add the
record.
4.
When you finish adding records, click Close to add
the new record and close the data form.
|