Claim Insert Dropdown List For Free

Create a drop-down listSelect 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.

Working with your drop-down listSelect the cells that have the drop-down list.Go to Data > Data Validation.On the Settings tab, click in the Source box. Then do one of the following: If the Source box contains drop-down entries separated by commas, then type new entries or remove ones you don't need.

Create a drop-down listIn a new worksheet, type the entries you want to appear in your drop-down list.Select the cell in the worksheet where you want the drop-down list.Go to the Data tab on the Ribbon, then Data Validation.On the Settings tab, in the Allow box, click List.More items...

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.

Open the Data Validation dialog box (Data tab > Data Validation). On the Settings tab, select List in the Allow box. In the Source box, type the items of your Excel validation list, separated by commas.

Right-click one of the cells you highlighted and click "Paste special." The Paste Special dialog box opens and displays several pasting options. Click "Validation" followed by "OK." Excel copies the drop-down list to the cells you selected.

1. Open the worksheet contains the drop down list you want to copy to Word document. 2. Select the drop down list cell and copy it by pressing the Ctrl + C keys simultaneously.