How to Create a Form in Excel (containing submit button-with example)

Friends do you know that we can make small software in Microsoft excel using by the formulas and menu buttons. So in this article I am going to tell you that how to create form in MS Excel.

How to Create Menu in MS Excel:-

First of All Click on Menu Icon and click on “Excel Options”

create-menu-in-excel-1

Now Go to Popular Tab and Click on Check Box Enable “Show Developer tab in the Ribbon”

create-menu-in-excel-2

Now Click on “OK” Button

You will see a developer menu at the last of menu bar

create-menu-in-excel-3

Now Click on Insert Menu then click on button which ever you want in your excel sheet.

create-menu-in-excel-4

Now Let me take an example:-

We are making a Simple Form Which have contained the basic information like Name, Age, Gender, Continent, Meals and Remarks.

So Click on Developers Tools button then click on Insert then click on “Group Box”

create-menu-in-excel-5

Now Drag on Excel Sheet and name the form for example I have entered “Information Form”

create-menu-in-excel-6

Type the heading in excel cells as you want in your form as under:-

create-menu-in-excel-7

Click on Developer Tab and click on Insert Button and Drag the items as you want in your form.

I am dragging Text Box for Name and Age, Radio Button (or Option Button) for Gender, List Box for Continent, Check Box for Meals and Text Box for Remark.

create-menu-in-excel-8

Making of Submit Button and Cancel Button in Excel:-

Now Insert “Submit” and “Cancel” Button at bottom of this form.

For making of “Submit” and “Cancel” button click on Developer Tab then click on Insert Button Then Click on Form Control Button.

create-menu-in-excel-10

after this Drag this button and Right Click on It and Click on Edit Tex

create-menu-in-excel-11

Name the Button “Submit” and again drag this button then name it “Cancel”.

After that your form is ready as below:-

create-menu-in-excel-9

So Viewers, above form is made in Microsoft excel using developers tool, this form is made physically, now this form is need addition function like how will data save in excel sheet by clicking on the Submit Button, so we will tell you that how to put functions in a form to save data in excel by clicking on Submit Button.

If you have any question or suggestion about “how to create form in excel”, feel free to comment in the comment box we will definitely solve your problem in the next article on our website TechGuruPlus.com

 


Leave a Reply

Your email address will not be published. Required fields are marked *