Opening dropdown box immediately on cell entry excel

[Jr66]

I have multiple drop down boxes using data validation on a spreadsheet, but instead of using the arrow on the right of cell I would like to be able to activate list by clicking on cell. Is this possible?

Thanks

Jeff

[The_Snook]

Hi Jr66,

You could achieve this by using a combo box which you will find on the Developer tab (see attached example).

Regards,

Snook