Drop Down List in a Cell

[Mike]

How do I get the drop down arrow to stay in the actual cell that I have the
info in? It only shows up when you click on the cell and the arrow is
outside of the cell. Thanks for any help.

[Jon Peltier]

That's how data validation works.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"Mike" <Mike@discussions.microsoft.com> wrote in message
news:A0546DF8-1E97-4D93-A46E-D718A3C4F00D@microsoft.com...
> How do I get the drop down arrow to stay in the actual cell that I have
> the
> info in? It only shows up when you click on the cell and the arrow is
> outside of the cell. Thanks for any help.