Excel Data Entry Form

 

Whenever I wanted to input data for my Tables in Excel, I would have a long time inputting the records one by one.  I discovered a handy trick in Excel that can turn my Table into a handy Data Entry Form!

Excel Data Entry Form

Say goodbye to inputting 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 steps below

*** SCROLL DOWN TO SEE OUR YOUTUBE VIDEO ON HOW TO CREATE A DATA ENTRY FORM IN EXCEL ***

 

DOWNLOAD EXCEL WORKBOOK

 

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

Excel Data Entry Form

Make sure My table has headers is also checked.

Excel Data Entry Form

 

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

Excel Data Entry Form

Excel Data Entry Form

 

STEP 3: Go to Customize Ribbon. 

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

Click New Tab.

Excel Data Entry Form

 

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

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

Excel Data Entry Form

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:

Excel Data Entry Form

 

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

Excel Data Entry Form

 

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.

Excel Data Entry Form

 

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

Excel Data Entry Form

 

VIEW OUR TUTORIAL ON HOW TO CREATE A DATA ENTRY FORM BELOW:

Excel Data Entry Form

 

VIEW OUR YOUTUBE VIDEO:

HELPFUL RESOURCE:

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

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+