Excel: Creating a dropdown list in cells

I've seen this a couple of times but never got around to figuring out how it works.


  • First, type up the cells which will be used as reference.
  • image 
  • Select the cells you want to apply the "dropdown list" to
  • Click on Data > Validation
  • Change "Allow" to "List"
  • Click the little weird icon in "Source"
  • image
  • Select the cells containing the list of items
  • image 
  • Confirm by clicking the little weird icon on the right.
  • image
  • Click OK
  • Now the dropdowns should be enabled.
  • image


Copyright © Twig's Tech Tips
Theme by BloggerThemes & TopWPThemes Sponsored by iBlogtoBlog