How to Add Check Boxes in Google Sheets | Scribe

    How to Add Check Boxes in Google Sheets

    • 13 steps |
    • 48 seconds
    • Google SheetsGoogle Sheets

    Add Custom Checkbox Values

    1
    On your computer, open a spreadsheet [https://docs.google.com/spreadsheets](https://docs.google.com/spreadsheets/d/11yQjHlR4yOj2gag5r98eh2RO4n2HyQOptMRENdhhltU/edit?gid=1564491323#gid=1564491323)
    2
    Select the cells you want to have checkboxes.
    3
    Click "Data" in the menu bar at the top.
    4
    Scroll down the dropdown menu and click on “Data validation”
    5
    A “Data validation rules” panel will appear on the right of your screen. Click the ”Add rule" button.
    6
    Click the arrow next to “Criteria”
    7
    Scroll down the dropdown menu and click on the ”Checkbox" option.
    8
    Click the checkbox next to “Use custom cell values”
    9
    Next to "Checked," enter a value. In this example, I entered “True”.
    10
    Optional: Next to "Unchecked," enter a value. In this example, I entered “False”
    information ordinal icon
    Tip! The custom checked value could be "Yes," and the unchecked value could be "No."
    11
    Click "Done" to apply the changes.
    12
    Click here to close the “Data validation rules” panel.
    13
    Now, your check boxes are inserted in your Google sheet.