| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I make Excel drop-down list values editable?
I have successfully created a drop-down list in a excel worksheet. One of
the values in the list is 'Miscellaneous'. If a user selects this option, I would them to be able to type in additional information in that cell. For example, they could type in 'Miscellaneous (New funds)'. Currently when I try this, I get error message "A user has restricted values that can be entered into this cell". |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I make Excel drop-down list values editable?
Make sure you remove any error alert check marks when you apply the
validation -- Regards, Peo Sjoblom "Mann" wrote in message ... I have successfully created a drop-down list in a excel worksheet. One of the values in the list is 'Miscellaneous'. If a user selects this option, I would them to be able to type in additional information in that cell. For example, they could type in 'Miscellaneous (New funds)'. Currently when I try this, I get error message "A user has restricted values that can be entered into this cell". |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make cell not editable | Excel Worksheet Functions | |||
| How do I make editable PDF forms using Excel? | New Users to Excel | |||
| How do I make longer a drop-down list (the window) in excel? | Excel Worksheet Functions | |||
| How do I make a drop down list to pick from for a cell in Excel | Excel Discussion (Misc queries) | |||
| Is there a way to make a drop down list in Excel that lets you se. | Excel Worksheet Functions | |||
Hybrid Mode
