Use Dynamic Range Names in Excel for Flexible Dropdowns Excel spreadsheets often include cell dropdowns to simplify and/or standardize data entry These dropdowns are created using the data validation feature to specify a list of allowable entries To set up a simple dropdown list, select the cell where data will be entered, then click Data Validation (on the Data If the list is on a different worksheet, enter the name that you defined for your list in the Source box In both cases, make sure that the reference or name is preceded with an equal sign (=) For example, enter =ValidDepts Make sure that the In Select the cell on your new worksheet where you want the list of names to start and click the Formulas tab You can add some headings above your list if you want, like we did below In the Defined Names section, click "Use In Formula" and select "Paste Names" from the dropdown menu You can also press "F3"
How To Edit Drop Down List In Excel Top 3 Ways With Examples