How to make it so only specific words can be typed in a cell

[inspirz]

Hi,

How do I do it so that a user can only input either: Hold, Y or N into a
cell - or a range of cells?

Mike

 

[BoniM]

Select the range, choose, Data > Validation from the menu bar.
Change Allow: to list and in the Source: text box type Hold, Y, N

 

[inspirz]

thanks - it worked.

Select the range, choose, Data > Validation from the menu bar.
Change Allow: to list and in the Source: text box type Hold, Y, N