1. Type in column A (A1 to A5) the following: Fruit (This is the name of the field); Apple; Pear; Banana; Strawberry.
2. Select A1 to A5 and click on the Formula tab and then the Create from Selection option and choose Top Row (You have just created a named field called Fruit).
3. Click on D1 then the Data tab and choose Data Validation - Data Validation.
4. Under Settings tab at the drop menu choose List.
5. Type “= Fruit” in the Source column. Choose OK.
6. Click on D1 and you will see a drop down list magically appearing. You may choose you option now.
Comments