Microsoft Excel 2013 - Using a Data Entry Form - How to Set Up and Use Built-in Form Tools

Sep 19, 2026

Upload by Cipher

Microsoft Excel 2013内置数据录入窗体用于快速把记录写入Excel数据库，并支持从已有表添加新记录、逐条浏览、按条件查找以及在需要时编辑或删除单条记录。内容重点说明如何在Quick Access Toolbar中添加“Form”按钮、先在工作表首行建立字段名、再打开窗体录入数据。还介绍窗体的数据工具，包括Find Prev/Next、Delete、Restore与Criteria，帮助维护数据完整性并定位匹配记录。

LanguageEnglish

CategoryForms

FormatPDF

Pages5

Reading Time2 min

AccessFree to download

Microsoft Excel 2013 Using a Data Entry Form

Add the Form button to Quick Access Toolbar

Add field names to the form

Open the data entry form

Add data records using the form

Use the form data tools (Find, Delete, Restore, Criteria)

Search records with one field name using Criteria

Search records with multiple field names using Criteria

Microsoft Excel 2013: Using a 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 The data entry form is one of Excel's built in data tools. To use it all you need to do is provide the column headings to be used in your database, click on the Form button, and Excel will do therest. To make things more challenging, however, Microsoft chose not to include the Form button on the ribbon. The first step to using the data entry form, is, to add the Form button to the Quick Access Toolbar so that we can use it. Add the Data Form to the Quick Access Toolbar 1. Click on down arrow at the end of the Quick Access Toolbar to open the drop down menu. 2. Choose More Commands from the list to open the Customize the Quick Access Toolbar dialog box. 3. Click on down arrow at the end of the Choose commands from to open the drop down menu. 4. Choose All Commands from the list to see all the commands available in the left hand pane. 5. Scroll through this alphabetical list to find the Form command. 6. Click on Add button between the command panes to add the Form command to the Quick Access Toolbar. 7. Click OK. 8. The Form button should now be added to the Quick Access Toolbar. This is a onetime operation. Once added, the Form button remains available on the Quick Access Toolbar everytime you use Excel as shown below. Adding Field Names to the Form 1. First we need to provide the column headings or field names to be used in our database. 2. The easiest way to add the field names to the form is to type them into cells in your worksheet on the first row. You can include up to 32 field names in the form. Opening the Data Entry Form 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. 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 Microsoft Office Excel message box. 4. The form containing all of the field names should appear on the screen. Adding Data Records Using the Form Once the data headings have been added to the form adding records to the database is simply a matter of typing in the data in the correct order into the form fields. Click New for each record. Using the Form's Data Tools A major problem with any database is maintaining the integrity of the data as the file grows size. This requires fixing data errors, updating individual records & deleting obsolete or duplicate records. The data entry form contains several tools along the right hand side that makes it easy to find and correct or delete records from the database. These tools are: The Find Prev and Find Next buttons-these allow you to scroll forward and back through the database one record at a time. The Delete button-this is used to delete records from the database. The Restore button-this can be used to undo changes to a record that is being edited. Occasionally, we make the wrong changes to a record or even edit the wrong record all together. If so, the restore button can be used to undo those changes. Note: the restore button only works as long as a record is present in the form. As soon as you access another record or close the form, the restore button becomes inactive. The Criteria button-allows you to search the database for records using one or more field names, such as name, age, or program. More below. Searching for Records Using One Field Name with the Criteria To start a search first open the Form then click on the

FAQs

Excel 2013的数据录入窗体主要用于哪些操作？

用于向新建或现有的Excel数据库表中添加记录、逐条滚动浏览数据、按条件搜索记录，并在必要时编辑或删除单条记录。

为什么需要把“Form”按钮添加到Quick Access Toolbar？

因为Excel的“Form”按钮默认不在功能区（ribbon）中，需将其加入Quick Access Toolbar后才能方便调用。

Criteria按钮和Find Next按钮如何配合搜索记录？

点击Criteria后窗体清空表单字段但不删除数据库数据，输入要查找的内容，再使用Find Next逐次定位匹配记录；完成后可再返回Form继续录入。

Restore按钮的可用条件是什么？

Restore只能在当前窗体仍包含该记录时生效；切换到其他记录或关闭窗体后，Restore会变为不可用。

Sep 19, 2026

Upload by Cipher