How to Update a Drop Down List in Excel | Scribe

    How to Update a Drop Down List in Excel

    • |
    • 0 step |
    • 32 seconds
      To begin, open your workbook in Excel.
      Click on the cell that contains the drop down menu you want to update.
      Click "Data" from the top menu ribbon.\ Then click "Data Validation" to open a 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.
      You can now click on your cell and select the down arrow at the bottom right corner to see your updated drop down menu.
      Was this Scribe helpful?
      Save this document for future reference.
      This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe