Nda Add Dropdown List For Free

Select 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.

Select 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.

Click on the cell which is being used for the drop-down list. Select the Data menu, and then click on Validation2026 A Data Validation window should appear (shown above) On the default Settings view you should be able to see the Validation criteria.

In 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. Click in the Source box, then select your list range.

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 Data > Data Validation. On the Settings tab, click in the Source box, and then on the worksheet that has the entries for your drop-down list, select all of the cells containing those entries. You'll see the list range in the Source box change as you select.

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.