Opcional Values

[Vanessa Simmonds]

Hi,

I am creating a form on excell which will be filled by the account managers.

In one of colunms I want them to fill only a values that it in a list of
possibles values.

Examples:
Possible Valours: Monday, Tuesday, Wednesday, Thursday and Friday.

So they will not be allowed to type August.

And to help them, I want to create a list of the possible values which
automatically appears when they start to type.

Examples: If they type T, a list with Tuesday and Thursday would appear, so
they just have to choice the right one.

Is it possible to be done.

Thank you very much,

Vanessa Simmonds

 

[Jim Thomlinson]

Your best bet is probably to use Data -> Validation -> List. Fill in your
accepted values and then you will have an in cell drop down. You can specify
the alert if the user tries to enter a value not in the list...