Excel has a feature called Data Validation that controls what the user can type into a cell. The entry choices include:
- Any Value
- Whole Number
- Text Length
Access Data Validation from the Data Tab.
Select the cells you want to control then click Data Validation. Change the settings for what you want to allow. In this example I will choose List since I want to control user input to a list of categories for the expense report. I will enter “Auto Rental, Airfare, Lodging, Meals, Parking, Tips” in the source line.
Click the Error Alert tab and write a message for the user to see after they enter bad data.
The error message will pop up after typing invalid data.
The user gets an error because they typed food and the proper choice is meals.
They will see a drop down list with the master list.