How to Add a Drop-down List in Excel

You must have seen some Excel spreadsheets with drop-down list. It’s quite convenient to select an option from the list instead of typing it by yourself. Therefore, I’d like to share some experiences of creating a drop-down list in Excel. 1. Select the cell you want to add drop-down menu. Click Data Validation in Data […]