How to lock create a drop down for existing data in google sheets | Scribe

    How to lock create a drop down for existing data in google sheets

    • Google SheetsGoogle Sheets
    1
    Navigate to <https://docs.google.com/spreadsheets/d/10Axadtr9yEauKXIfEqDtLH6Ta8E1hat5JejyOpCy5hA/edit#gid=0>
    2
    Click here.
    3
    Right-click here.
    4
    Click here.
    5
    Click here.
    6
    Click here.
    7
    Click here.
    8
    Click here.
    9
    Click here.
    10
    Click here.
    11
    Click "Color"
    12
    Click here.
    13
    Click here.
    14
    Click here.
    15
    Click "Advanced options"
    16
    Click here.
    17
    Click "Done"