View Single Post
  #2   Report Post  
Ruthki
 
Posts: n/a
Default


use data validation - it will restrict the entries to items that are
validated.
if you use the List option you can refer to a list of the two options
in another part of the spreadsheeet.
Once data validations is set up when you go to the cell you will see
the drop down arrow on the right.

Ruth


--
Ruthki
------------------------------------------------------------------------
Ruthki's Profile: http://www.excelforum.com/member.php...o&userid=24503
View this thread: http://www.excelforum.com/showthread...hreadid=383572