Creating Forms in Excel: Become A Master Craftsman

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:
Click a cell in the labeled row you want to add the record to.
On the Data menu, click Form.
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:
Click New.
Type the information for the new record.
When you finish typing data, press the ENTER key to add the record.
When you finish adding records, click Close to add the new record and close the data form.

Posted By: http://www.dataentryindia.com

Category Posted: General