You can easily create a drop-down list in Excel to limit the values that can be entered in a column. Here's how to set one up.

You can lock cells in Excel by heading into the program's "Protection" tab. There, you can set a password, and protect your data.