Dropdowns are useful features that simplify data entry and enforce data validations in spreadsheet ... Microsoft Excel. We will also show you how to make a colored and nested drop-down list.