Drop Down Menus in Excel
  1. Click on cell A41. Type "Lesson 5".
  2. Click on cell A42. Type "Sectors".
  3. Click on cell A43. Type "Cable and Satellite".
  4. Click on cell A44. Type "Chips".
  5. Click on cell A45. Type "Computers/Peripherals".
  6. Click on cell A46. Type "Contract Manufacturers".
  7. Click on cell A47. Type "Internet".
  8. Click on cell A48. Type "Networking".
  9. Click on cell A49. Type "Software".
  10. Click on cell A50. Type "Storage".
  11. Click on cell A51. Type "Tech Blue Chips".
  12. Click on cell A52. Type "Telecom".
  13. Click on cell A53. Type "Telecom Global".
  14. Click on cell A55. Type "Wireless".
  15. Click on the column header "C" so the whole column is highlighted.
  16. Right click and select "Insert."
  17. In cell C2, type "Sector".
  18. Highlight from cell C3 to cell C12.
  19. Go up to the "Data" menu. Select "Validation."
  20. In the "Settings" tab and the "Validation Criteria" box, find and select "List" from the "Allow" drop down menu.
  21. After "Allow", find the "Source" area.
  22. Click on the white box with the little red arrow to the right of the white area below "Source". This should take you back into the spreadsheet. A new, smaller window called "Data Validation".
  23. Highlight cells A43:A55.
  24. The "Data Validation" window should have =$A$43:$A$55 in it.
  25. Click on the gray box with the red arrow in the "Data Validation" window.
  26. You should be back in the "Data Validation" window on the "Settings" tab.
  27. Click OK to exit "Data Validation".
  28. Click on cell C3. A down arrow should now appear. Click on the arrow to see the drop down menu.
  29. Select the appropriate category for each company. Use CNN/Money to find the sector for each of your companies.
  30. If a company is listed in two or more categories, just pick one, it doesn't matter which.
  31. Important: Notice that all of your columns beyond column "B" have shifted to the left. This will change some of the "constants" in your formulas in the future (i.e. "Purchased" is now in "F", not "E".
Hosted by www.Geocities.ws

1