I have a data validation dropdown with a list of possible values, and if the cell is empty or has a value, the dropdown list will show correctly.

But if the cell contains a formula, the dropdown list will not show and clicking on the dropdown arrow will enter cell editing.

Is this by design?


1 Answer 1


pretty much yes, to return on selectable items on dropdown menu you need to select a cell and delete it with Delete

to avoid it use green aproach:

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.