Adi,

If I'm understanding you correctly you're wanting the data in the dro
down list (data validation list) to appear in the list only and nowher
else on the sheet. If this is correct you can do this by going t
DataValidation. In the Allow box click on List. In the Source bo
enter the data you want followed by a comma after each entry t
seperate them. For instance:

1, 2, 3, 4, 5 or January, February, March, April, May. However, if yo
have a lot of data it may be best to use a defined range name that'
hidden somewhere on the worksheet. Let me know if this is what you'r
needing

--
patel
-----------------------------------------------------------------------
patele's Profile: http://www.excelforum.com/member.php...fo&userid=3584
View this thread: http://www.excelforum.com/showthread.php?threadid=56122