Excel Tutorial 1

[SmokiestGrunl]

Creating drop down boxes with list

 

 

Creating drop down boxes is really simple. Before continuing make sure Excel is open.

 

 

1. First click on the second sheet tab.
   
   
2. Start by writing the list that you wish to be in the drop down box.
   
   It is not necessary to add a header, but it is suggested so that you can remember what the list is for. There can be as many list items as needed.
    
   
3. Next select the list items, excluding the header.
   
   
4. Now click on ‘Insert’ on the main menu, then ‘Name’ -> ‘Define’.
   
   You should now see the following box.
   
   You may name the list what ever you want, but we suggest you use a name related to the list.
    
   
5. Now that you have named the list you are going to want to create the drop down list. First go back to Sheet 1 and click on ‘Data’ on the main menu, then click ‘Validate’.
   
   You should now see this box.
   
   
6. Now change ‘Allow:’ to ‘List’. You should now see a ‘Source:’ bar, type “=’Then what ever you called your list’” in our case it was li1, so we typed ”=li1”.
   
   
7. Congratulations, you should now see an arrow that will display your list when clicked.
   
   

Edited November 1, 2008 by SmokiestGrunl

[sillybob123]

Well i guess thanks for the tutorial but dont you think its a little random?

[SmokiestGrunl]

Well i guess thanks for the tutorial but dont you think its a little random?

 

I had to create it for school and I just thought I would post it here.