Menu
I'm having to do a little bit of user data validation in Excel which will be used for application upload. I have a list of values (LOVs) that I'm providing in a drop down box in an Excel. That's easy.
Is there a way to also allow for free form text in the drop down list cell? Excel tries to validate it against the given LOVs. I don't need the user-entered text to become part of that LOV, just that it is possible to 'override' or put additional text in there instead?
352
Edit a drop-down list with items that have been entered manually. On the worksheet where you applied the drop-down list, select a cell that has the drop-down list. Go to Data > Data Validation. On the Settings tab, click in the Source box, and then change your list items as needed.
In the Validation dialog, go to the "Error Alert" tab and uncheck "Show error alert after invalid data is entered".
155
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
