If you use a combo box from the Forms toolbar the drop arrow is always
visible however, a combo box acts a bit differently than a data validation
drop down list. If you use the selected item in formulas then it's slightly
more complicated but simple once you learn how to do it.

Another option is to continue to use the data validation drop down list but
put a border around the cell or use a fill color that makes it stand out.
Maybe put a label in the cell above that says something Pick From List.

--
Biff
Microsoft Excel MVP


"it''''''''sh hardy" wrote in message
...
I have 2 drop down boxes on my spread sheet... People don't see the drop
down
box so they just type answers next the cell... How can I make the drop
down
arrow visible, and please note I am using Excel 2003