How To Work With Named Ranges In Microsoft Excel
Go to the Data tab Select the data validation option You will get the dialogue box which will show validation criteria Choose the List option from the dropdown list Place the cell in the F column as shown below in the screenshot to get the dropdown listThe column names for personal data have to named as follows!email!id!mother!father!birthday!address!phone!parentemail!group But , as stated, you can add your own fields like !emergency , !phone2 , etc This looks nice but I'd need a CSV sample file Here a small CSV sample file, it has some personal fields, grades and a user defined field