How to Insert CheckBox in Google Sheets

Google Sheets has added some great functionalities. It also included to easily insert a checkbox in any cell with a single click. Here is how you can insert a checkbox in Google Sheet. 

Steps

1. Open the Google Sheets that you want to insert the checkbox.
   
   
2. Select the cell in which you want to insert the checkbox.
   
   
3. Click Insert > Checkbox.
   
   
4. To delete checkboxes, select the checkboxes you want to remove and press Delete.

How to Add custom values in checkboxes

1. Open the Google Sheets that you want to insert the checkbox.
   
   
2. Select the cell in which you want to insert the checkbox.
   
   
3. Click DataData validation.
   
   
4. Choose the Checkbox from the dropdown in the Criteria list. 
   
   
5. Enter a value next to checked and unchecked.
   
   
6. Choose a validation option next to invalid data. 
   
   
7. To show a validation message when someone hovers over the checkbox, select Show validation to help text and enter your message.
   
   
8. Click Save.

How to Format the Checkbox

A checkbox is a part of the cell, you can format it just like any other cell.

1.  Apply a color to the cell and the checkbox will change the color from gray to the selected color.
   
   
2. You can also change the font in case you want bigger checkboxes.
   
   
3. You can sort and filter these since it is part of the checkbox.