Drop Down Menu's

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Hi Rob

I believe, it's not possible.
Maybe you could give all cells with a validation menu
the same colour?
 
Thanks for the reply. I am very surprised it's not possible. Oh well... plan
b....

Regards,

Rob
 
Can I create a drop down menu in Word (I have no idea how to), then cut and
paste into Excell?
 
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.
 

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

Similar Threads

drop downs showing down arrow 4
Copying a Drop Down Menu 2
Usability - drop down box - Arrow INSIDE box? 1
Displaying Drop-Down Menu Options 2
The drop down menu of my validation list needs to display more. 2
Making Drop Down Box Visible with Excel 2003 2
drop down list 2
In-Cell Drop Downs not visible 2

Back
Top