Data entry using Validity

Hello,

I would like to use the Data Validity to enter a value from a list. My problem is that although I can see the values listed I can’t select any.

Why?

My setup

I click on a cell.

Data - Validity

Criteria

Allow:
List
“Allow empty cell” selected.
“Show selection list” selected

My entries are:

Conformity
Nonconformity

Input Help

“Show input help when cell is selected” selected

Title: Conformity

Input help:

Conformity
Nonconformity

So my problem is that when I click on a cell I can see the Input help but I can´t selecte any of the entries shown.

Any clue about what am I doing wrong?

Thanks in advance for your help

Did I understand your problem correctly?

image

2 Likes

Silly me,

Your question gave me the answer to my silly problem.

I just didn’t click the down arrow so I couldn’t see the list and make a selection.

Thanks