Yes if you mean entering using a keyboard.

http://www.cpearson.com/excel/NoDupEntry.aspx

but it won't prevent it if someone pastes something

--


Regards,


Peo Sjoblom

"Jana Thornsberry" wrote in
message ...
Is there a way to prevent entering duplicate data in a range of cells
within
a column?
--
Sincerely,
Jana