When I create a dropdown list via Data > Validity > Criteria > List
I can only tell this is a dropdown list when I click the cell, without this it looks like an ordinary cell.
How can I make it so the arrow shows permanently - ie lets the user show its intention.
My image below shows the cell when its clicked on, I would like it to appear like this all the time
AFAIK you can’t. What you can do is to colour the background, add a border or even put an image in the background of the cell. It might be better to change the label to “Select Width”, “Select Height”, etc.
IdentifyDataValidityCell.ods (11.7 KB)
…or you can use a graphical Form Control Element (ComboBox) - instead of the Data Validuty reature -, aligned to the Cell and anchored to the Cell.
ComboBox.ods (9.9 KB)