Visibility:Drop Down Arrow

[bengaluru]

I have a drop down menu with various options using Data>> Validation.

The arrow for the drop down menu is visible only when you select the particular cell. Is there a way we can have the arrow permenant so that users know that there is a deop down menu without selecting the cell ??

thanks for your help,as always.

[royUK]

Use a ComboBox

[bengaluru]

Thanks roy.

I did try a Combo Box and wanted some changes, but unable to delete it from my sheet now. For some reason I am unable to select the combo box to use my right click to cut.

Any clues how I delete my combo box.

[royUK]

presumably you have used the Controls Toolbox, make sure this is open from the View menu. next click the Design View icon - looks like a set square. You can now select the combobox

[bengaluru]

Excellent. Thank a lot roy. You are a Pro, I guess.

Have a great weekend, my friend.

[royUK]

Glad it helped, remember to click out of Design View when you have finished.