Learn how to create a dynamic drop down list in Excel.br br Here are the steps.br A) Create List Data Tablebr 1) Select the list data cells.br 2) Ctrl + Tbr 3) Check on "My table has headers"br 4) OKbr br B) Create Data Validation Listbr 1) Select a cell.br 2) Data -- Data Validationbr 3) Allow set to Listbr 4) Source set to =$C$2#br br C) Expanding Data Validation Listbr 1) Select last item in the Data Listbr 2) Tabsbr 3) Add list item.