to create drop down list in Excel-Microsoft Office in any version just you need to follow the few given steps and then it will done.

  • Create list in cells B1:B4 (or any). Similarly, you can enter the items in a single row, such as A11.
  • Select cell E3.
  • Select Validation from the Data menu.
  • Select List to Allow option's drop-down list.
  • Press the Source control and drag to highlight the cells B1:B4. Alternately, simply enter the reference (=$B$1:$B$4).
  • Make sure the In-Cell Dropdown option is checked. If you unchecked this option, Excel still forces users to enter only list values (B1:B4), but it won't present a drop-down list.
  • Click OK.