Homehow ToMicrosoft Excel: How to Create a Basic Form

Microsoft Excel: How to Create a Basic Form

Have you used tools like Microsoft Forms, Google Forms or even Microsoft Word to create forms. But if you are more comfortable using Excel, why not use it to create the form you need? Here's how.


See also: Microsoft: Disables Excel 4.0 macros by default

Activate the Developer Tab in Excel

To use the tools you need to create a form in Excel, you must enable the Developer tab. If you already see this tab, you are one step ahead and can go to the next section. If not, see how you can display the Developer tab.

Open Excel and go to File> Options. Click "Customize Ribbon" on the left side of the Excel Options window.

On the right, use the Customize the Ribbon section and select "Main Tabs" in the drop-down box. Then, below, select the Developer box and click "OK".


When Excel Options closes, you should see the Developer tab.

See also: Microsoft Excel: How to create a dependent drop-down list

Create a form in Excel

To add controls to your form, such as drop-down lists, buttons, or list boxes, go to the Controls section on the Developer tab.

Navigate to a point in your sheet where you want to add a control and click the Insert drop-down arrow. Select the control you want to add, then use the plus sign that appears to draw its size.

For example, we will enter a drop-down list using a "form control".

Click the Combo Box icon from the form items and draw the box.

Select the Combo Box and click on "Properties" in the Controls section of the ribbon.

On the Control tab, enter the Input Range which are the cells that contain the list items. You can also drag cells to fill in this field. Click "OK".

Then you have a nice and neat to-do list.

As another example, we will introduce some Yes and No check boxes. Click on icon of the check box from the form elements and draw the first check box. Make sure the size is wide enough to fit the text you want next to the check box.

Right-click on the control, select "Edit Text" and enter the text you want to appear.


To customize additional options for the form control, such as making the box appear unselected, select the control and click "Properties" on the ribbon. Make your adjustments and click "OK".

Next, we follow the same procedure to create the next check box. Now our form is really taking shape!

You can use these types of controls for your form or select others such as buttons, scroll bars and option buttons.

See also: How to use the LEN function in Microsoft Excel

Protect your form

If you plan to share the form digitally, you may want to protect it from unwanted changes to the text and controls.

Go to the Review tab and select "Protect Sheet" in the Protect section of the ribbon.

Select all the options you want and optionally include a password. Note that if you do not request a password, another user may remove the sheet protection. Click "OK".


When you share it spreadsheet, others will be able to use the form controls but not edit them or other elements on the sheet you are protecting. If they try, they will receive an error message informing them that the sheet is protected.


If you want to make additional changes to your form, click on "Unprotect Sheet" on the "Review" tab.

Source of information: howtogeek.com

Teo Ehchttps://www.secnews.gr
Be the limited edition.