Thread: Drop Down Menu
View Single Post
  #8   Report Post  
Chris Bode Chris Bode is offline
Member
 
Location: Sweden
Posts: 30
Default

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