How do I add a drop-down list to a Google Sheets spreadsheet? | Scribe

    How do I add a drop-down list to a Google Sheets spreadsheet?

    • Grace Everwood |
    • 0 step |
    • 14 seconds
    Go to [https://sheets.google.com](https://sheets.google.com) and open the spreadsheet you want to add a drop-down list to.
    Click the cell where you want to add the drop-down list.
    Click the “Data” tab at the top of the page.
    Click the “Data Validation” button.
    In the “Criteria” section, select “List from a range” from the drop-down menu.
    In the “Range” field, enter the range of cells that contain the list of items you want to appear in the drop-down list.
    Click the “Save” button.
    Was this Scribe helpful?
    Save this document for future reference.
    click-target-circles-background
    This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe