All you need to do is follow these steps: Also: How to add a drop down list in Google Sheets No formula is needed to create drop-down lists in Excel. All you need to do is change how the data is ...