It can't. You need to use a combobox for that.

--
HTH

Bob Phillips

"srf1030" wrote in message
...
I used the validation command, however I want the arrow button to show at
all
times. Not just when you move the mouse to that cell. Do you know how to
do
that?

"JE McGimpsey" wrote:

Take a look at Validation in XL Help.

In article ,
"srf1030" wrote:

How do I add a drop down menu to a spreadsheet?