Thread: How do i set up data validation to only enter yes or no?
View Single Post
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default How do i set up data validation to only enter yes or no?
Select cell(s). From the menu, choose Data--Validation, choose List, type
in the box: yes,no
That's it!
************
Anne Troy
www.OfficeArticles.com

"renee" wrote in message
...
I need to know how to set up data validation that only allows the user to
type y or n in a cell.


Reply With QuoteReply With Quote