Showing Dropdown Arrow Box In Validation

  • I have many validation drop down lists on a spreadsheet. Right now as the default, if the cell is NOT selected, the dropdown arrow to the far right does not appear. Is it possible to somehow always show these arrows even when the cell is not selected? Kind of like the dropdown lists from User Forms - they show you the dropdown arrows as long as there are choices to be selected.

  • Re: Showing Dropdown Arrow Box In Validation


    Quote from farful

    I have many validation drop down lists on a spreadsheet. Right now as the default, if the cell is NOT selected, the dropdown arrow to the far right does not appear. Is it possible to somehow always show these arrows even when the cell is not selected? Kind of like the dropdown lists from User Forms - they show you the dropdown arrows as long as there are choices to be selected.


    Not really. What you could do, however, is format the cell as grey, and change the cell's line shading (bold to the right and bottom, thin at the top and left--to give it a 3D effect), and then put in a couple graphics representing arrows (from the Menu - View - Toolbars - Drawing). Then, above the cells, put in "Click to Select" or something of that nature, so that they know the cells have choices.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!