I know how to enter a yes/no drop down option in excel using data validation and lists. But is there anyway to tab across these cells and enter 'y' or 'n'o and get excel to enter yes/no for you and then tab to the next cell?

currently if i try it I get an error message because y/n isn't allowed in those cells only yes/no?

Thanks in advance for your help