How to Create a Data entry form in Excel

i) To create a data entry form in Excel

ii) Write a format for data entry that for work

iii)Click on file tab

iv)Click customize ribbon, Check with Form

v)Click through new group and new tab

vi)Now we can add some option which you want in new tab

vii)Rename the new tab as Data entry

viii)Open the data entry tab that created. We can see the form was generated.

ix)Now start working with your data entry easily