Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
List and Data Validation
What we'd like to do is be able to add text to whatever drop down value we
choose to drop into a cell in those columns. Right now, once you select a drop down value and then try to add to it, Excel gets says "a user has restricted values in this cell." If we can select a drop down value ... and then modify it a little, we can remove columns C and F from our spreadsheet. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
List and Data Validation
Datavalidationerror alert
-- Don Guillett Microsoft MVP Excel SalesAid Software "Erika" wrote in message ... What we'd like to do is be able to add text to whatever drop down value we choose to drop into a cell in those columns. Right now, once you select a drop down value and then try to add to it, Excel gets says "a user has restricted values in this cell." If we can select a drop down value ... and then modify it a little, we can remove columns C and F from our spreadsheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003. Data/Validation/Settings - Allow/List: sizing list? | Excel Discussion (Misc queries) | |||
data validation list: how do i 'force' a user to enter data from the list? | Excel Discussion (Misc queries) | |||
data validation list: how do i 'force' a user to enter data from the list? | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions |