Excel Data Entry Form

By Ted French, About.com Guide

Opening the Data Entry Form

For help with this example, see the image above.

1. Click on cell A2 to make it the active cell.


2. Click on the form button that was added to the Quick Access Toolbar in step one.


3. Clicking on the form button will bring up a message box from Excel containing a number of options related to adding headings to the form.


4. Since we have already typed in the field names we want to use as headings all we have to do is Click OK in the message box.


5. The form containing all of the field names should appear on the screen.

Previous

• Using a Form for Data Entry in Excel
• Finding the Data Entry Form Button
• Adding the Database Field Names
• Opening the Data Entry Form
• Adding Data Records with the Form
• Adding Data Records with the Form (con't)
• Using the Form's Data Tools
• Searching for Records Using One Field Name
• Searching for Records Using Multiple Field Names

Next