Jonathan has provided you with the answer. If it's only those 4 options, you
can type them in like he says.
Here's my article on it:
http://www.officearticles.com/excel/...soft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"AB" wrote in message
...
Example:

I have a large spreadsheet that will be used by many. What I am trying to
do is restrict all words that are entered into column A excpet for the
following Open, Close, Stop, Go. That is to say if I enter a word with
more
than 4 letter that Excel will not allow it and show a warning message.
Please let me know if you need more.

Thanks.

"Anne Troy" wrote:

Please provide an example.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"AB" wrote in message
...
Hi All,

I am trying to learn how to restrict what is entered into my worksheet.
I
am trying to set a limit on what words can be entered into a particular
column on my spreadsheet for security purposes but I am having alsorts
of
trouble. I have scanned through the data validation section in the
help
function but still do not understand how it works. Can someone please
explain how I can go about doing this?

Thanks.