1. Computing

Excel Data Entry Form

By

1 of 9

Using a Form for Data Entry in Excel
Using the Form to Enter Data in Excel

Using the Form to Enter Data in Excel

© Ted French

Overview: Using a Data Entry Form in Excel

Related tutorial: Excel 2003 Data Entry Form.

Using Excel's built in data entry form is a quick and easy way to enter data into an Excel database.

Using the form allows you to:

  • start a new database table or to add new records to an existing one
  • scroll through data records one at a time
  • search for records containing specific information
  • edit or delete individual records if necessary

Tutorial Topics

  1. Finding the Data Entry Form Button

  2. Adding the Database Field Names

  3. Opening the Data Entry Form

  4. Adding Data Records with the Form

  5. Adding Data Records with the Form (con't)

  6. Using the Form's Data Tools

  7. Searching for Records Using One Field Name

  8. Searching for Records Using Multiple Field Names

©2014 About.com. All rights reserved.