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.

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.

Assuming that you want someone to be able to say "Yes" or "No", in a specific
cell and Excel 2003.

Select that cell. Click on DATA--VALIDATION

Then under where it says "Allow", select the drop down box and select LIST.

For a short list, you would just type the following onto the line below the
word SOURCE.

Yes,No

That's it. Just type the words Yes, a comma without any spaces, the word
No. Hit enter, and your done.

If your list of allowable answers is longer than that, then click below
where it says source, and select a range of cells on the SAME worksheet that
contains the list of allowable answers.

Does this help?

"AB" wrote:

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.

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.

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.

Thank you both. I appreciate it. I think I have figured out with your help.

"Jonathan Cooper" wrote:

Assuming that you want someone to be able to say "Yes" or "No", in a specific
cell and Excel 2003.

Select that cell. Click on DATA--VALIDATION

Then under where it says "Allow", select the drop down box and select LIST.

For a short list, you would just type the following onto the line below the
word SOURCE.

Yes,No

That's it. Just type the words Yes, a comma without any spaces, the word
No. Hit enter, and your done.

If your list of allowable answers is longer than that, then click below
where it says source, and select a range of cells on the SAME worksheet that
contains the list of allowable answers.

Does this help?

"AB" wrote:

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.