On Feb 6, 9:37 pm, Alex wrote:
This seems to be something not covered on the Webpage on dependant listshttp://www.contextures.com/xlDataVal02.html

I notice with the dependant lists it allows you to enter free form text,
unlike the master list which wont allow this. Is there a way of making the
dependant lists like any normal list in that you can't enter free form text?

Have you thought about using the list on one sheet (even hiding it if
necessary), and then using define names (Insert Name Define), and
then on the worksheet that you want the drop-down list (as this is
what I am thinking that you are after, you can then use Data
Validation for you list... Data Validation...

Change the drop-down on the dialogue to list and then put in
=[DefinedNameHere]

And then you can extend the validation to the cells that you want...
The only draw back is that text can be entered but it has to match
what is already in the list you defined, and if it doesn't it will
prompt the user to either retry or cancel what they are doing