software

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

quot;ABquot; gt; wrote in message
...
gt; Hi All,
gt;
gt; I am trying to learn how to restrict what is entered into my worksheet. I
gt; am trying to set a limit on what words can be entered into a particular
gt; column on my spreadsheet for security purposes but I am having alsorts of
gt; trouble. I have scanned through the data validation section in the help
gt; function but still do not understand how it works. Can someone please
gt; explain how I can go about doing this?
gt;
gt; Thanks.
Assuming that you want someone to be able to say quot;Yesquot; or quot;Noquot;, in a specific
cell and Excel 2003.

Select that cell. Click on DATA--gt;VALIDATION

Then under where it says quot;Allowquot;, 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?

quot;ABquot; wrote:

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

quot;Anne Troyquot; wrote:

gt; Please provide an example.
gt; ************
gt; Hope it helps!
gt; Anne Troy
gt; www.OfficeArticles.com
gt;
gt; quot;ABquot; gt; wrote in message
gt; ...
gt; gt; Hi All,
gt; gt;
gt; gt; I am trying to learn how to restrict what is entered into my worksheet. I
gt; gt; am trying to set a limit on what words can be entered into a particular
gt; gt; column on my spreadsheet for security purposes but I am having alsorts of
gt; gt; trouble. I have scanned through the data validation section in the help
gt; gt; function but still do not understand how it works. Can someone please
gt; gt; explain how I can go about doing this?
gt; gt;
gt; gt; Thanks.
gt;
gt;
gt;

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:
www.officearticles.com/excel/...soft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

quot;ABquot; gt; wrote in message
news
gt; Example:
gt;
gt; I have a large spreadsheet that will be used by many. What I am trying to
gt; do is restrict all words that are entered into column A excpet for the
gt; following Open, Close, Stop, Go. That is to say if I enter a word with
gt; more
gt; than 4 letter that Excel will not allow it and show a warning message.
gt; Please let me know if you need more.
gt;
gt; Thanks.
gt;
gt; quot;Anne Troyquot; wrote:
gt;
gt;gt; Please provide an example.
gt;gt; ************
gt;gt; Hope it helps!
gt;gt; Anne Troy
gt;gt; www.OfficeArticles.com
gt;gt;
gt;gt; quot;ABquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Hi All,
gt;gt; gt;
gt;gt; gt; I am trying to learn how to restrict what is entered into my worksheet.
gt;gt; gt; I
gt;gt; gt; am trying to set a limit on what words can be entered into a particular
gt;gt; gt; column on my spreadsheet for security purposes but I am having alsorts
gt;gt; gt; of
gt;gt; gt; trouble. I have scanned through the data validation section in the
gt;gt; gt; help
gt;gt; gt; function but still do not understand how it works. Can someone please
gt;gt; gt; explain how I can go about doing this?
gt;gt; gt;
gt;gt; gt; Thanks.
gt;gt;
gt;gt;
gt;gt;
Thank you both. I appreciate it. I think I have figured out with your help.

quot;Jonathan Cooperquot; wrote:

gt; Assuming that you want someone to be able to say quot;Yesquot; or quot;Noquot;, in a specific
gt; cell and Excel 2003.
gt;
gt; Select that cell. Click on DATA--gt;VALIDATION
gt;
gt; Then under where it says quot;Allowquot;, select the drop down box and select LIST.
gt;
gt; For a short list, you would just type the following onto the line below the
gt; word SOURCE.
gt;
gt; Yes,No
gt;
gt; That's it. Just type the words Yes, a comma without any spaces, the word
gt; No. Hit enter, and your done.
gt;
gt; If your list of allowable answers is longer than that, then click below
gt; where it says source, and select a range of cells on the SAME worksheet that
gt; contains the list of allowable answers.
gt;
gt; Does this help?
gt;
gt; quot;ABquot; wrote:
gt;
gt; gt; Hi All,
gt; gt;
gt; gt; I am trying to learn how to restrict what is entered into my worksheet. I
gt; gt; am trying to set a limit on what words can be entered into a particular
gt; gt; column on my spreadsheet for security purposes but I am having alsorts of
gt; gt; trouble. I have scanned through the data validation section in the help
gt; gt; function but still do not understand how it works. Can someone please
gt; gt; explain how I can go about doing this?
gt; gt;
gt; gt; Thanks.