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 |
    • 7 steps |
    • 14 seconds
    1
    Go to [https://sheets.google.com](https://sheets.google.com) and open the spreadsheet you want to add a drop-down list to.
    2
    Click the cell where you want to add the drop-down list.
    3
    Click the “Data” tab at the top of the page.
    4
    Click the “Data Validation” button.
    5
    In the “Criteria” section, select “List from a range” from the drop-down menu.
    6
    In the “Range” field, enter the range of cells that contain the list of items you want to appear in the drop-down list.
    7
    Click the “Save” button.