Create Dropdown List Document For Free

Step 2: Create the Drop-down List Using Data ValidationSelect the cell or cells you want the drop-down list to appear in.Click on the Data tab on Excel's ribbon.Click on the Data Validation button in the Data Tools group.In the Data Validation dialog, in the Allow: list select List.Click in the Source: box.More items...

To select multiple items in a list, hold down the Ctrl (PC) or Command (Mac) key. Then click on your desired items to select. All of the items you have selected should be highlighted with a different-colored background. Note: Be sure to hold the Ctrl (PC) or Command (Mac) key down while selecting multiple items.

Place the cursor in the form where you want the multi-selection list and then go to the Controls Task Pane (View > Design Tasks > Controls). Under the Repeating and Optional section, click Multiple-Selection List Box. Configure the multi-select list box as you would a standard List Box.

Start typing in the combo box, and it will autocomplete. Press Enter, to add the combo box item to the list selections. Then, click OK, to add all the selected items to the cell.

Other tipsClick the first file or folder you want to select.Hold down the Shift key, select the last file or folder, and then let go of the Shift key.Hold down the Ctrl key and click any other file(s) or folder(s) you would like to add to those already selected.Aug 16, 2021

Open Word 2010 and click the "File" tab. Select "Options." Click the "Customize Ribbon" left option. Click the "Developer" tab. Type the word or phrase that you want to appear in the drop down list and click "Ok." Repeat this step until you have included all of the words for the list.

A lot of people have been asking about the code to select multiple items from a drop-down list without repetition.This code will allow you to select multiple items from the drop-down list. However, you will only be able to select an item only once. If you try and select it again, nothing would happen (as shown below).