First, you make a regular data validation list.
How to create drop down list and display different values in excel. In data validation dialogue box, select the settings tab. In settings tab, select “list” in the. The data validation dialog box displays.
Web in the data tools section of the data tab, click the “data validation” button. Web here are the steps to create a drop down list in a cell: Web how to create a dropdown list there are several ways to populate list items when you create a dropdown list within your spreadsheet.
Select the data you want to use and type a name for it in the name. You can add or delete items from your drop. Web how to create drop down list but show different values in excel?
Then, customize the list using the data validation options.