How to Add a Check Box in Google Sheets
In this article, you will learn how to make a tick box and utilize it in Google Sheets. It is helpful because you can use a check box simply as a tick box for to-do management or as a trigger of Conditional Formatting with other formulas.
How to make a check box in Google Sheets
- Select a cell or a range you want to insert a check box.
- Navigate to the “Insert” tab → “Checkbox”.
- Done
![How to Add a Check Box in](https://cdn.prod.website-files.com/61f27b4a37d6d71a9d8002bc/63545a102c95bea14e4b8a1d_EeXdbyNT2PWPomG1ynElZHU37DvKjt3oCdEi80PQDMifSdEbsQAoXTe-MiER9Txmd2-Z9v8VHYbGzL1e7GAUxCPlZH7uORVX6Shrwdgkspw9LzNcDFocSdD5ggoJ2BhFxyD-oOpqf0riFjUf3oZC-kCsglCOirF4zv0byXeRUi7YTgrwmPDyWbG_9Q.png)
How to put a customized check box in Google Sheets
- Select a cell or a range you want to insert a check box.
- Go to the “Data” tab → “Data validation”, which shows up a pop-up window.
- Move to the drop-down list in the “Criteria” section and choose “Checkbox”.
- Check the box next to “Use custom cell values”.
- Insert the two values shown when the check box to be inserted is checked or not.
- Click the “Save” button..
![How to Add a Check Box in](https://cdn.prod.website-files.com/61f27b4a37d6d71a9d8002bc/63545a1002780eadc4f191ab_6OgepHFAa-gW2zHyqcB9ClX4KcvSmBE_w3fXZaGOeufzsJOEkiSQrGccgr8N_AvMC-iri_jSjZQzly0J6IGzAVp-etUeh6J9-osgKNwUWtJrAFDa0SrhmNanCdFe_rsEvKpuo0aoomvyhC79kwyFrq7mDoWsaXHdwahlqGz1IJPKbeEN_TkxGTcvww.png)
Check this article if you are interested in Data Validation.
How to use a tick box in Google Sheets
As a check box can switch two values in a cell, it is often used with other functions such as IF, IFS, SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS, and/or Conditional Formatting. In the following cases in the picture, the checkboxes are general check boxes used as Conditional Formatting triggers.
Example 1: Project management: In this example, when you check a box, the entire row that has the tick box is highlighted in dark grey.
![How to Add a Check Box in](https://cdn.prod.website-files.com/61f27b4a37d6d71a9d8002bc/63545a1073b8d5737af8e397_Db0Tcor36LXBlIsMSZB0nDZqC_QZZIsmlo6qqWUzSbIJL2Qdl9bWFIF0kQL_pavx57hnEyq8ZRCTaLrIG88iTQTEAm8S_9SB6LVPXBZm9Ldflpjs3auw1-4kWW02Ldr6pLBhOA0oMvOMrraEGwJwxDf28WO1EYjIWsExgNc_Ic6bRi-VJBcAbNQf9Q.png)
Example 2: Formatting adjustment: When you click the check box, font colors change to block, and fill colors turn white. This is effective when you print out your spreadsheet with simple formatting.
![How to Add a Check Box](https://cdn.prod.website-files.com/61f27b4a37d6d71a9d8002bc/63545a10b687d6700f0cbca2_qqV27ggiCKnA2A8Gc_YhpIROFZhi7aQPMC3e-bUIjeuYq0vkfG1u6ZrzXdzVvPhx9kpe0_HIy-TFlpBzul-InPrV9nKO8OUj76Bz54ZsVoi9GJ6tXVWpiuTtY1nYdRRP6KlwwomGn4t_4t7epFMLWNte1Gwzcz7ocQSOJRylYvU7EDyQOuKIAE5zRg.png)
The following picture shows the Conditional Formatting settings for the two examples above.
![How to Add a Check](https://cdn.prod.website-files.com/61f27b4a37d6d71a9d8002bc/63545a102c95bec19a4b8a1e_JxW2vRGCKpFJdYFHPoLui_xPs2lTY-eiUTcQw8GI4tqrgy1r8OTBgAXNDcqIstoX5om9ADf0rWEyI2xrVbYyFr4I_WOWi5jQsbUC2q76avL79TqZKpM2bEMdx2QtA0IHfW6LtPqhsI3PhjF6TQ5MJbcQemiVD1fFv_nCT9e_VKfJNG00rQ64f6GC5A.png)
Check these articles if you are keen to learn more about Conditional Formatting.
Conditional Formatting in Google Sheets: Explained
Conditional Formatting Based on Another Cell Value in Google Sheets: Explained
How to delete a check box in Google Sheets
- Select the cell(s) containing the check(es) box you want to delete.
- Press the “Delete” button.
- Done.