[jho]

I created a drop down menu in Excel 2000 but, the drop down arrow for my custom menu is only visable when my curser is in the cell where I created the menu.

How do I make the drop down arrow visable at all times (regardless of where my curser is located)?

Thanks.

[Advertisements]

How did you create the drop down
ther is more then 1 way in excell

[peterm]

How did you create the drop down
ther is more then 1 way in excell

[jho]

I went the Data tab, Validation and selected the range of data.

I tried to use the Auto Filter (which shows the drop down arrow at all times) but I need to create several drop down menus in the same column (one below another) and Auto Filter won't let me do that.

Any thoughts?

Thanks for your consideration.

[peterm]

Ok pretty sure you can't have the drop down arrow showing all the time.
If you do it hides part of the data in the next cell.
or try this
Excell

[jho]

Thanks for your help.