IOU Add Dropdown Menu Fields For Free

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.

Add data validation to a cell or a rangeSelect one or more cells to validate.On the Data tab, in the Data Tools group, click Data Validation.On the Settings tab, in the Allow box, select List.In the Source box, type your list values, separated by commas.Make sure that the In-cell dropdown check box is selected.More items...

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.

Copy drop-down list from one cell to anotherCopy the cell by pressing Ctrl + C or Right-click -> Copy.Select the cells where you want to paste the drop down list.Right-click, select paste special, click on Validation and press OK"Nov 22, 2016

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.

Go to the Data tab on the Ribbon, then Data Validation. On the Settings tab, in the Allow box, click List. Click in the Source box and then select your list range. Then check the In-cell dropdown box.

Select the entire column you want to validate.Click on "Data Validation" from the Data tab.Choose "List" from the "Allow" box.Click on the arrow to the right of the "Source" box and select the cells containing the allowed values.Jun 6, 2018