Help with odd Excel behaviour - Data Validation

C

Colin Foster

Hi,
Two issues...
First one is I've applied some Data Validation to restrict data entry to
values in a list (referred via Named Range) . However, whilst the Data
Validation is providing a pick list to select from, it doesn't prevent entry.
Any suggestions? Error Alert type is set to STOP.

Secondly, is there any way to have the pick list in alphabetical order?

Cheers
Colin Foster
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
Data validation 3
2007 data validation not working 1
Data Validation help 5
pick multiple items in data validation 2
Data Validation 1
Using Data Validation in a Table 0
get Data Validation to stop, list supplied, duplicate data entries 1

Top