Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with odd Excel behaviour - Data Validation
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Abnormal behaviour" data entry form | Excel Discussion (Misc queries) | |||
strange behaviour in Excel 2003 when importing XML | Excel Discussion (Misc queries) | |||
Excel 2007 - Autofilter different behaviour | Excel Discussion (Misc queries) | |||
Strange behaviour - loading Excel clears Clipboard | Excel Discussion (Misc queries) | |||
Odd behaviour in dragging data across and up and down cells | Excel Discussion (Misc queries) |