Hi umesh,

That is a very vague request and a simple web search will turn up many examples.

For starters, see:
http://support.microsoft.com/kb/211485
http://office.microsoft.com/en-us/ex...010072600.aspx

You can also limit data entry to data in dropdowns and have dependent dropdowns. See attached.

Attached Files

Dependent Dropdowns.xls (241.0 KB, 12 views)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]