Hi Suril,

This facility is offered by rhe built in Data Validation feature.

See Debra Dalgleish's web page on Data Validation which provides a tutorialt
with step by step instructions ilustrated wit numerous informative
screenshots.

---
Regards,
Norman



"Sunil Patel" wrote in message
...
Hi

I need a list to appear eg (A1:A12) when a cell is clicked. Then when a
list item is clicked i need it to be entered into the cell. Help much
appreciated