Adding a drop-down list in Excel is a quick and efficient way to choose predefined data. Here's how to create a drop-down list in Microsoft Excel.

Head to your Excel database, and when you want to add a new value, right-click on a cell and select Pick From Drop-down List. Select one of the existing values and you are good to go.

Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.