Please follow following steps
1.Click to sheet2 and enter your data in Column A as
A
I-Phone
Desktop Computer
Laptop Computer
Touch Screen Monitor
Wireless Internet Connection
2.Now select all the data you have entered in sheet2 Column A
3.Now name it as Devices by typing ‘Devices’ on the name bar to the left of formula bar
4.Move to sheet1
5.Select cell A2
6.Click DataValidation from the toolbar
7.Click Setting tab from the data validation window
8.Select List from Allow drop down list
9.In the source box type following
=Devices
10.Click OK
Now You are done!
Click the button that appears next to cell A2 and check it
Have a nice time……
Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com