EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Tools Excel Forms for Data Entry
Secondary Sidebar
Excel Functions
  • Excel Tools
    • Excel Shortcut Redo
    • Reduce Excel File Size
    • Quick Analysis in Excel
    • Goal Seek in Excel
    • Compare Two Lists in Excel
    • Excel Quick Analysis
    • Estimate Template in Excel
    • Pivot Table Count Unique
    • CSV Files into Excel
    • Excel Business Plan Template
    • Excel Export to PDF
    • Free Excel Template
    • Excel Repair
    • Color in Excel
    • Form Controls in Excel
    • Timecard Template in Excel
    • How to Unhide All Sheets in Excel?
    • Power Query in Excel
    • Power View in Excel
    • XML in Excel
    • Excel Evaluate Formula
    • Examples of Excel Macros
    • Consolidation in Excel
    • Ribbon in Excel
    • Excel Conditional Formatting for Dates
    • Protect Sheet in Excel
    • Data Model in Excel
    • Pivot Table Examples
    • Pivot Table Slicer
    • Pivot Table Filter
    • Watch Window in Excel
    • Slicer in Excel
    • Print Gridlines in Excel
    • Convert Numbers to Text in Excel
    • Freeze Columns in Excel
    • Spelling Check in Excel
    • Name Box in Excel
    • Solve Equation in Excel
    • Excel Spreadsheet Examples
    • What If Analysis in Excel
    • How to Print Labels From Excel
    • Excel Named Range
    • Excel TRANSPOSE Formula
    • Excel Merge and Center
    • Excel Freeze Rows
    • HLOOKUP Formula in Excel
    • Excel Create Database
    • Excel Gridlines
    • Excel Spreadsheet Formulas
    • Excel Sort By Number
    • Excel Concatenating Columns
    • Excel AutoCorrect
    • Conditional Formatting For Blank Cells
    • Excel Icon Sets
    • Excel CTRL D
    • Excel Accounting Number Format
    • Excel Regression Analysis
    • Excel Import Data
    • Excel Freeze Panes
    • Excel Calendar
    • Excel Developer Tab
    • Excel Enable Macros
    • Excel Autosave
    • Heat Map in Excel
    • Excel Toolbar
    • Excel Error Bar
    • Excel Status Bar
    • Excel Unprotect Sheet
    • Check mark in Excel
    • Excel Column Filter
    • Excel Header and Footer
    • Excel Drawing
    • Range in Excel
    • Timeline in Excel
    • Excel Lock Formula
    • Excel Table styles
    • Insert New Worksheet in Excel
    • Excel Column Lock
    • Excel Forms for Data Entry
    • QUOTIENT in Excel
    • Excel Sorting
    • Excel Sort by color
    • Excel Data Bars
    • Excel Tool for Data Analysis
    • Excel Flash Fill
    • Excel Auto Fill
    • Excel Quick Access Toolbar
    • Excel Wrap Text
    • Excel Exponential Smoothing
    • Excel ANOVA
    • Excel Merge Two Tables
    • Excel Conditional Formatting in Pivot Table
    • Dynamic Tables in Excel
    • Excel Sort by date
    • Excel Dynamic Range
    • Record Macro in Excel
    • Two Variable Data Table in Excel
    • Merge Cells in Excel
    • One Variable Data Table in Excel
    • Excel Fill Handle
    • CheckBox in Excel
    • Excel Table
    • Excel Combo Box
    • Auto Format in Excel
    • Advanced Filter in Excel
    • Excel AutoFilter
    • Excel Data Filter
    • Excel Data Validation
    • Excel Radio Button
    • Data Table in Excel
    • Text to Columns in Excel
    • Excel List box
    • Excel Solver Tool
    • Scrollbar in Excel
  • Excel Functions (12+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Training
  • EXCEL Training COURSE

Excel Forms for Data Entry

By Jeevan A YJeevan A Y

Data Entry Form in Excel

Excel Forms for Data Entry (Table of Contents)

  • Data Entry Form in Excel
  • Steps for Adding the Form Feature in Excel
  • How to Create Data Entry Form in Excel?

Data Entry Form in Excel

In excel, we have a Form command which we can use it for creating Forms in Excel. To activate the forms in excel, go to Option in the File menu, then select Forms from the Customize Ribbon menu list. The form is available under the Commands Not In Ribbon dropdown. Once activated, on selecting the Form from the menu tab, we will get the custom form that will pick all the headers from the sheet as its fields.

Steps for Adding the Forms Feature in Excel

We can add the FORM in excel by customizing the ribbon. In order to add the Form to the Home tab, follow the below steps.

Step 1 – Go to the File menu and Choose Option.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

Excel Form Step 1

Step 2 – We will get the below dialogue box as shown below. Next, choose the Customize Ribbon.

Excel Form Step 2

Step 3 – We will get the customize ribbon dialogue box where we can add or remove the ribbon.

Excel Form Step 3

Step 4 – Search for the FORM button, create a new group in the HOME menu.

Excel Form Step 4

Step 5 – After creating ‘ New Group ‘ click on ‘ Add ‘

Excel Form Step 5

Step 6 – So that form will be added under Main Tabs in New Group as shown below.

Excel Form Step 6

We can see that FORM has been added in the new group in the Main menu, as shown in the below screenshot highlighted in yellow color.

Excel Form Step 7

How to Create Data Entry Forms in Excel?

The creation of the data entry form in Excel is very simple and easy. Let’s understand how to create a data entry form in excel with some examples.

You can download this Data Entry Form Excel Template here – Data Entry Form Excel Template

Example #1

Creating Form in excel

In order to create a proper excel data entry form, we should maintain accurate data in the table so that it will be easier for the end-user to add, view, and edit it.

Let’s see in this example how to create a normal employee data entry form in excel, which is shown below.

Now we have created an employee database with their designation and KRA.

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,452 ratings)

Excel Form Example 1-1

Let’s see now how the excel form is used to add and delete the employee record in the below examples.

Adding New Employee

In this example, we are going to see how to add a new employee record in the existing employee database by following the below steps as follows.

  • Click on the Form button on the Home Menu.

Excel Form Example 1-2

  • Once we click on Form, we will get the form dialogue box as shown below.

Excel Form Example 1-3

The form dialogue box contains command buttons like New, Delete, Restore, Find Prev, Find Next, Criteria, and Close.

  • New: Which will add new records to the database.
  • Delete: Delete the specific records of the employee.
  • Restore: Restore the old record.
  • Find Next: Finds the next record.
  • Find Previous: Find the Previous record.
  • Criteria: Displays the records based on the employee criteria.
  • Close: This will close the form window.
  • Scroll Bar: Where we can scroll up and down to see the record fields.

Now let’s add a new EMPLOYEE record by hitting the New Command button.

  • Click on the NEW command button, So that it will ask for the employee data.

Excel Form Example 1-4

  • Update the fields like DATE, EMP ID, NAME, DESIGNATION, and KRA.

Excel Form Example 1-5

Here we have updated employee records with the specified data, which will be added to the database as per date-wise order. Therefore, new employee records will be added to the database as shown below with new employee records, and we can see the employee count has been increased to 21.

Excel Form Example 1-6

Example #2

Deleting Employee Record

In this example, we will see how to delete the employee’s record. Then, follow the below steps to delete the employee records.

  • Click on the selected cell.
  • Click the form button so that we will get the form dialogue box which is shown in the below screenshot.

Excel Form Example 2-1

  • We can see that the total number of records has been displayed as 21 of 21 records in the FORM window.
  • Click on the command button to search which employee data needs to be deleted using the Find Next and Find Previous command button.
  • Click on delete.

Excel Form Example 2-2

  • Once we click on the DELETE command button, we will get the below msg box shown below; the Form window will confirm whether to permanently delete the data. Click OK.

Excel Form Example 2-3

Here note down that we will delete the employee name VAMSEE KRISHNA, whose EMP ID is 1010, for our reference to check the data is deleted or not.

After deleting the record, we will get the below database as follows, where we can see that the employee count has been decreased to 20, which means that EMP ID 1010 has been deleted successfully.

Excel Form Example 2-4

Example #3

How to Edit and Update Names in excel data entry forms

In this example, we will see how to edit and update the saved employee name database by following the below steps.

Consider the below employee database where it has employee id with their name, designation, and KRA. Assume that we need to edit and update employee designation from the saved employee list database.

Excel Form Example 3-1

We can edit and update the employee designation by following the below procedure.

Step 1 – The first click on the cell which designation name we need to edit, and in this example, select the first designation name MIS- OPERATION, which is shown below.

Excel Form Example 3-2

Step 2 – Click the form button so that we will get the form dialogue box which is shown in the below screenshot.

Example 3-3

Step 3 – Now edit the Designation Name as Marketing which is highlighted in yellow color as shown below; after editing the Designation name as MARKETING, click the Close button.

Example 3-4

Step 4 – The Designation name will be getting updated as MARKETING, which is highlighted in yellow in the below screenshot.

Example 3-5

Example #4

Fetching the record Criteria wise

In this example, we will see how to fetch the records based on the employer’s criteria. For example, assume that management wants to fetch the records of employees who work under the MYNTRA field. In this scenario, “CRITERIA” can be used to fetch the exact records as follows.

We will consider the same employee database where we can see KRA is unique for each employee, which is highlighted in the below screenshot.

 Example 4-1

To find the criteria wise employee database, follow the below steps:

  • First, Click on the specific cell KRA as shown below.

Example 4-2

  • Click on the form button so that we will get the form dialogue box which is shown below. Now click on the CRITERIA button,

Example 4-3

  • Once we click on the CRITERIA button, all the fields will become blank, as shown below.

Example 4-4

  • Place the cursor on the KRA field.
  • Type the KRA name as JAVA which is shown in the below screenshot.

Example 4-5

  • Now hit the enter button.
  • Once we hit the enter button, FORM will search for the CRITERIA named JAVA, and it will fetch all the employee records, which are shown in the below screenshot.

 Example 4-6

As we can see for the criteria name “JAVA,” which is the third record in the database showing 3 of 21 in the form, which is marked in the above screenshot in red color and it fetches all the employee records like date, emp id, name, and designation.

Things to Remember in excel forms

  • Maintain a proper table with appropriate records so that it will be easy for the excel data entry form templates.
  • Make sure that always select the cell before using the form button, or else excel will throw an error alert message.

Recommended Articles

This has been a guide to Data Entry Form in Excel. Here we discuss how to create Data Entry Form in Excel, practical examples, and a downloadable excel template. You may learn more about excel from the following articles –

  1. One-Variable Data Table in Excel
  2. Data Filter in Excel
  3. Excel Data Formatting
  4. Excel Data Visualization
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel Training (23 Courses, 9+ Projects)4.9
31 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Data Entry Form Excel Template

EDUCBA

Download Data Entry Form Excel Template

EDUCBA

डाउनलोड Data Entry Form Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more