You can use Excel to create interactive digital forms that other people can fill out on their computers before printing or sending them back to you. It takes a little preparation, but using forms simplifies data entry and ensures accurate input. There are many different form controls available to add to a worksheet, like a check box or a list to select from.
Once you've enabled the Developer tab and created the layout and structure of the form, you can start adding form fields to your worksheet with form controls.
Click the Developer tab.
Click the Insert button.
There are two categories of controls in the menu. The Active X controls are more complex, but more flexible, and can be used with VBA code. If you just need to do something simple, stick to a regular form control.
Select a form control.
Click, or click and drag, to place the form control.
Right-click the form control.
Select Format Control.
The Format Control dialog box opens, displaying all the available options for setting how the form control behaves. The options that display here will vary depending on the type of control you’ve added.
Any time you insert a control that contains a list of information, those values must be listed in a cell range in the workbook. If you don’t want the list of selectable values visible in the workbook, you can always create a separate sheet to hold all the form control list values, and then hide the sheet.
Modify the form control settings.
The control options available in the Format Object dialog box will vary depending on the type of form control you’re modifying.
The form control is added to the worksheet and can now be used.