Need permanent data validaty down arrow

asked 2018-11-10 23:21:15 +0100

Todd2 gravatar image

updated 2018-11-12 18:13:21 +0100

Hi All,

I have successfully set up several calls with "data Validity" cell ranges. You click inside the cell and you get a drop down arrow to on the far right of the cell to click on to find your values. Works nicely

Problem: the user is not skilled enough to realise there is a drop down until he clicks inside the cell. In other words, he won't realize he needs to click inside the cell to get the down arrow.

Is there a was to get the down arrow to stay on permanently, even when the cell is not activated?

Many thanks, -T

edit retag flag offensive close merge delete


As a workaround, I drew in an arrow

Todd2 gravatar imageTodd2 ( 2018-11-11 03:35:06 +0100 )edit