Restricted Usage

A

AB

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.
 
J

Jonathan Cooper

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?
 
A

AB

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.
 
Top