See the "Prevent entry of invalid data in a cell" topic in XL Help

In article ,
George wrote:

I have a column where the entries are always going to be one of four or five
codes, for simplicy sake lets say it is A, B, C, D or E. How do I set it up
that if anything else but one of those letters is entered, the cell will not
accept it.