Skip to content
Related Articles

Related Articles

Improve Article

Data Entry Form in Excel With Examples

  • Last Updated : 03 Jun, 2021

Data Entry Form is a form that helps to enter the data with the help of a form in which the data can be added, searched, and previous data can be deleted. Data entry in Excel without forms can be very time-consuming. There are many two major issues faced while conducting data entry without forms in Excel:

  1. Time-consuming: Without forms, data needs to be entered in one cell at a time, then go to the next cell and enter the data for that cell, and so on. Sometimes, due to confusion the user might need to scroll up and see which column is it and what data needs to be entered and then come back to the current position. Similarly, in the case when the user needs to scroll right and then comes back to the beginning.
  2. Error-prone: If there is a huge dataset that needs 100 entries to be entered in the form. In that case, there may be a possibility that the user unintentionally enters the wrong data in the cell.

Data entry using forms in Excel helps to overcome all these limitations and makes the task of entering data less time-consuming and less error-prone.  In this article, Let’s have a look into how to Data Entry Form in Excel. 

Adding Data Entry Form Option To Quick Access Toolbar:

Step 1: To add the Data Entry Form option on Quick Access Toolbar. First, right-click on any of the existing icons in the Quick Access Toolbar. Then, click on “Customize Quick Access Toolbar…”

Customize quick access toolbar



Step 2: In the “Excel Options” box select “All Commands” in “Choose commands from”. 

All the commands

Step 3: Select “Form…” from the list of commands then click on “Add>>”, and then click Ok.

Form...

Step 4: Now, the Form icon is added on Quick Access Toolbar.

Form icon added

Using Data Entry Form: This section will discuss the steps to use the data entry form in Excel.

Step 1: Select any cell from any column and then click the “Form” icon.



Select form icon

Step 2: After that to add a new row click on “New” in the Sheet1 box.

Click on New

Step 3: Then, Add Name, Age, and Class, and then click Close.

Add details

Now, our row is added.

Row is added

To Find Next Data- Follow the steps below to find the next occurrence of the required data-

Step 1: Select any cell from any column and then click the “Form” icon.

Select form icon



Step 2: Click on “Find Next” in the Sheet1 box.

Find Next

To Find Previous Data: Follow the steps below to find the previous occurrence of the required data-

Step 1: Select any cell from any column and then click the “Form” icon.

Select form icon

Step 2: Click on “Find Prev” in the Sheet1 box.

Find Prev

To Delete Row: Follow the steps below to delete a row-

Step 1: Select any cell from any column and then click the “Form” icon.

Select form icon



Step 2: Click on “Delete” in the Sheet1 box.

Delete

Step 3: Click Ok in the Microsoft Excel box.

Click OK

Step 4: The selected row is deleted.

Row deleted

To Get All Dataset Using Given Set Of Criteria: Follow the steps below to delete a row-

Step 1: Select any cell from any column and then click the “Form” icon.

Select form icon

Step 2: Click on “Criteria” in the Sheet1 box.

Click on criteria

Step 3: Criteria is used to get the required dataset, and then use “Find Prev” or “Find Next” to get the previous value or next value of that criteria. 

Step 4: The required data is obtained using the criteria.

Data obtained using criteria

Attention reader! Don’t stop learning now. If you are an Excel beginner (or an intermediate) and want to learn Excel, Geeksforgeeks brings the perfect course for you to start, Diving Into Excel




My Personal Notes arrow_drop_up
Recommended Articles
Page :