One way:

Data/Validation/Settings:

Allow: List
Source: Y,N

In article ,
Courtneyf04 wrote:

I need to have one column set up so that all that can be entered into it is
either a capital Y or capital N. I appreciate the help. Working in Excel
2007. Thanks!