Drop Down Menu's

A

abfabrob

I can create a drop down menu by clicking data and then validation, but when
I click in another cell, the drop down arrow (next to the cell) disappears.
Is there a way to keep that arrow on display, regardless of which cell you
click in? So that it is always obvious that there is a drop down menu?

If anyone has the answer, please put it in simple terms - I'm new to Excell!

Thank you,

Rob.
 
L

Leo Heuser

Hi Rob

I believe, it's not possible.
Maybe you could give all cells with a validation menu
the same colour?
 
A

abfabrob

Thanks for the reply. I am very surprised it's not possible. Oh well... plan
b....

Regards,

Rob
 
A

abfabrob

Can I create a drop down menu in Word (I have no idea how to), then cut and
paste into Excell?
 
D

Debra Dalgleish

You can create dropdown lists in Word by using the Drop-Down Form Field
tool on the Forms toolbar. However, you won't be able to copy and paste
this into Excel.

In Excel, you can create dropdown lists by using the combobox from the
Forms toolbar, or from the Control toolbox.

You may find them more difficult to use than data validation lists.
 
Top