DROP DOWN LIST

In Excel 2010 (May be same in excel 2007) first select a cell where you want to drop down list.

Choice data ribbon—>Data Validation—>Data Validation–>settings tab—>allow—>list…

just select some cells (column wise) and ok.

you can put the criteria like HM, AT, Peon etc. in this selected cells you will find those in the drop down list.

For Excel 2007
Select at top bar menu:
Data-> Data Validation-> Data Validation-> Settings->
In validation criteria:
Allow: List
Source: HM, AHM, AT (Just write the name separate by a comma)

Dear Mr. Chanchal babu,
The problem you faced is not in the Staff info.The School info contains a number of Drop down Lists.Please look at the bottom of that page. You will find some columns with specific headings. Choose the column(s) and modify the rows where some letters are written. You may modify those and add some new designations.You may create drop down list according to your will. First create a Column entitled as Designation any where in the sheet of your choice. Then Write the designations such as Headmaster
Asst.Teacher
Clerk
Peon
Matron
After that select any cell of your choice on that sheet where you like the drop down list. Write ‘Cookie’ in that cell , then go to Data Tool , then go to Data validation, go to settings, then choose List,Click Source, you will find data validation. Then select the entire List which you have previously created( other than heading)-After noting select symbol go to the source again, ClIck OK, THE DROP DOWN LIST will be noticed in’ the cookie’ cell. This is easy.
Debabrata Paul

THANK YOU DEB DA ,AND FRIEND.

you have type dp