How to Update a Drop Down List in Excel | Scribe

    How to Update a Drop Down List in Excel

    • |
    • 5 steps |
    • 32 seconds
      1
      To begin, open your workbook in Excel.
      2
      Click on the cell that contains the drop down menu you want to update.
      3
      Click "Data" from the top menu ribbon.\ Then click "Data Validation" to open a pop up window.
      Click "Data" from the top menu ribbon.\ Then click "Data Validation" to open a pop up window.
      4
      Make changes to your drop down menu in the "Source" text field under Settings. Click "OK" to exit the pop up window.
      Make changes to your drop down menu in the "Source" text field under Settings. Click "OK" to exit the pop up window.
      5
      You can now click on your cell and select the down arrow at the bottom right corner to see your updated drop down menu.
      You can now click on your cell and select the down arrow at the bottom right corner to see your updated drop down menu.