Learn Excel Episode 378: Cell Dropdown
If you are creating a worksheet for someone else to fill out, why not provide dropdowns where the person can choose the valid values from a dropdown list? It is easy to do. It makes life easier for the person filling out the form. It makes sure the data that comes back to you is correct. Episode 378 shows you how.