Add Data Entry Form in Excel 2016

You can quickly add a data entry form in Excel 2016 in just a few clicks. The steps to add a data entry include adding the form to your quick access menu and creating a table with headings for the data to be entered and finally initiating the table. Yes, that is all that is needed 3 easy to follow steps to have on your very own data entry form.

Check out the Video Instructions

Step 1: Add the Form Option to Your Quick Toolbar Menu

First, you will need to access the options menu. Follow the instruction below to do this.

  1. Click File.
  2. Click Options.
  3. Click  Quick Access Toolbar.
  4. Choose All Commands from the Choose command from option.
  5. Scroll down to Form.
  6. Add it to the Quick Access Toolbar.

Now you will be able to see the quick access icon form forms at the top of the ribbon, you can use it to convert a table into a form with a single click now.


you can quickly add the form as a quick access item

Step 2: Create a Table

You simply need to create a table with the heads that will act as your data entry fields. For example. I created a table with Product, Price, Customer,  and Store. I would like these to be my data entry headings in my form.

  1. Type your column headings
  2.  Click Insert from the top ribbon
  3. Choose Table
  4. Insert the table with headings


Step 3: Change the Table to a Form

  1. Simply highlight any part of the table and click your form icon.
  2. Enter your data.

use the form as a data entry form using these excel options

Gaelim Holland

Notify of

Inline Feedbacks
View all comments