View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brian Brian is offline
external usenet poster
 
Posts: 683
Default only allow one cell inputed for a range of cells

I am making a spread sheet to be used for data entry. the data entered is an
"x" with in a column. But I only want to allow one cell from f13:j13 to be
entered
Ex f13 is unsat g13 in below ave h13 is average and so on so by puting an
"x" in f13 it totals down and I don't want a double entry within the range of
f13:j13