Quick One
Home » Technology » Internet and Browsing » How to create a check box in Google Spreadsheet
How to create a check box in Google Spreadsheet

How to create a check box in Google Spreadsheet

Fullscreen%20capture%203142011%20120519%20PM How to create a check box in Google Spreadsheet
1. Select the cells you want to act like check boxes
2. Apply a data validation via Tools->”Data validation…”
3. For the Criteria, select “Items from a list”.
4. Select the “Enter list items” radio button.
5. In the box, enter the character you want to use as a check character.  You don’t have to restrict yourself to keyboard characters.  Your system’s Character Map may be helpful.  I use the square root symbol (√) because it is the most check mark similar character in the Times New Roman character set.  The wingdings character set has a check mark, but Google Docs doesn’t support languages other than their default (which I assume is Times New Roman? or one of the standards).
6. Check the box “Show list of items in a drop-down menu”.
7. Uncheck the box “Allow invalid data, but show warning”.
8. Click Save.
This box can now be either the check mark symbol or nothing.  No other value will be accepted.  A check mark can be entered using the drop down menu in the cell.
Credit Goes to: JoRyTe


  1. Thanks, exactly what I was looking for, “S :razz: ometimes the best solution is …”

  2. Thank you. Worked great! :)

  3. Rupert Swanepoel

    Thx – works like a charm!

  4. Thanks so much not the ultimate checkbox but definately a solution.

    Thanks again!

  5. On latest Google Drive “Data Validation” appears under Data -> Validation…
    Also in Win 7, the Character Map may be found in All Programs-> Accessories -> System Tools -> Character Map

  6. Thanks! :)

  7. Thanks a lot

Leave a Reply

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>