How to Create a Drop-Down List in Excel
A drop-down list lets people pick a value instead of typing it, so entries are consistent and typing mistakes disappear. You make one with Data Validation, from a range of cells, a typed list, or a Table that grows by itself. WhereData → Data Validation → List Open a listAlt + ↓ Grows automaticallySource in … Read more