Q. How can I create a drop-down list in Excel?
A. You can accomplish this a couple of ways. If you have a specific set of choices you’d like work sheet users to choose from, and you want it restrictive (only these values), use the Data Validation tool (on the Data tab, Data tools group). Choose the List selection from the Allow: field. From here, you can type your values separated by a comma (like Yes, No, NA) or refer to a cell range or named range for your choices.
To help users, complete the Input Message and Error Alert tabs, too. Alternatively, if you just want users to select from entries already entered in the column, all they have to do is right-click and choose Pick from Drop-down List.