Creating drop down boxes with list
Creating drop down boxes is really simple. Before continuing make sure Excel is open.
- First click on the second sheet tab.
- 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.
- Next select the list items, excluding the header.
- 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.
- 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.
- 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”.
- Congratulations, you should now see an arrow that will display your list when clicked.
Edited by SmokiestGrunl, 31 October 2008 - 11:24 PM.