Complete Dropdown Form For Free

In your document, place your insertion point where you want to add the drop-down list. Next, select the Developer menu. On the Developer menu, in the Controls group, click the Drop-Down List Content Control icon (It looks like an actual drop-down icon.). You now have a drop-down list in your document.

Create a drop-down list Select the cells that you want to contain the lists. On the ribbon, click DATA > Data Validation. In the dialog, set Allow to List. Click in Source, type the text or numbers (separated by commas, for a comma-delimited list) that you want in your drop-down list, and click OK.

Also, Data Validation doesn't have an AutoComplete feature, which finds matching items in the list as you start to type. To overcome these limitations, you can add a combo box to your worksheet, and use programming to make it appear in cells that contain a data validation list.

Create a drop-down list Select the cells that you want to contain the lists. On the ribbon, click DATA > Data Validation. In the dialog, set Allow to List. Click in Source, type the text or numbers (separated by commas, for a comma-delimited list) that you want in your drop-down list, and click OK.

Select a cell or cells that reference your Excel Data Validation list, i.e. cells containing a drop-down box that you want to edit. Click Data Validation (Excel ribbon > Data tab). Delete or type new items in the Source box. Click OK to save the changes and close the Excel Data Validation window.

You can use a drop-down list box in a Microsoft Office InfoPath form template to present a list of mutually exclusive choices to a user. The list is hidden until the user clicks the arrow to the right of the drop-down list.

I hope this helps. Choose dropdown as question type on Microsoft Forms. List all answers you would like to add as dropdown on an excel sheet. On excel sheet, select all and copy (CTRL+C) Paste (CTRL+V) them to first answer option space on Microsoft Forms.