Drop down list question



I have created a drop down list on sheet 1 from named lists on sheet 2, does
anyone know how to make the drop down arrows stay visible as opposed to only
showing when the cell is clicked on?

Your help is greatly appreciated.



Gord Dibben

Not possible using DV list dropdowns.

Color the cell with the dropdown.

Draw a little triangle in the corners of the cell.

Use a ComboBox instead of DV dropdown.

Gord Dibben MS Excel MVP

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question