In this tutorial we will show you how to create a Data Entry Form in Excel.

Whenever I wanted to enter data in Excel, it would take me a very long time inputting these records one by one, but I discovered a handy trick that can turn my Excel Table into a handy Data Entry Form in Excel!

Create a Data Entry Form in Excel

Say goodbye to inputting entering data into this Table row by row by row by row….

I will show you how easy it is to create a Data Entry Form in Excel with the following quick video below (scroll further down to see the step by step instructions after you watch this awesome video).

*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***

Watch on YouTube and give it a thumbs up 👍

 

Want to know how to use Macros and VBA in Excel?

*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***

Watch on YouTube and give it a thumbs up 👍

Create a Data Entry Form in Excel

DOWNLOAD EXCEL WORKBOOK

 

STEP 1: Convert your Column names into a Table, go to Insert> Table

Create a Data Entry Form in Excel

Make sure My table has headers is also checked.

Create a Data Entry Form in Excel

 

STEP 2: Let us add the Form Creation functionality.  Go to File > Options

Create a Data Entry Form in Excel

Create a Data Entry Form in Excel

 

STEP 3: Go to Customize Ribbon. 

Select Commands Not in the Ribbon and Form.  This is the functionality we need.

Click New Tab.

Create a Data Entry Form in Excel

 

STEP 4: Under the New Tab, select New Group and click Add.

This will add Forms to a New Tab in our Ribbon.

Create a Data Entry Form in Excel

Notice that there is also a Rename button, you can use it to rename the New Tab and New Group into something more descriptive, like Form:

Create a Data Entry Form in Excel

 

STEP 5: Select your Table, and on your new Form tab, select Form.

Create a Data Entry Form in Excel

 

STEP 6: A new Form dialogue box will pop up!

Input your data into each section.

Click New to save it.  Repeat this process for all the records you want to add.

Press Close to get out of this screen and see the data in your Excel Table.

Create a Data Entry Form in Excel

 

You can now use this new form to continually input data into your Excel Table!

Create a Data Entry Form in Excel

 

STEP 7: 

 

 

6

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin