You can make data entry easier by adding a drop down list on an Excel worksheet.
In most cases, you want people to select an item from the list, to prevent typos and invalid entries. If they try to type something that's not in the list, they'll see an error message, and will have to try again.
Allow Non-List Entries
In some workbooks though, you might want to allow other entries in those cells, in addition to the items in the drop down list.
To allow other entries, you can turn off the Error Alerts in the
Continue reading Allow Other Entries With Excel Drop Down List