View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
inspirz inspirz is offline
external usenet poster
 
Posts: 5
Default How to make it so only specific words can be typed in a cell

thanks - it worked.

"BoniM" wrote:

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" wrote:

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