Having checkboxes in your Google Sheet can come in handy when you have items to be crossed off your list. Fortunately, inserting checkboxes in Google Sheets is a straightforward process.
Using the Checkbox option
Step 1: Highlight the desired cell.
Click on the cell to insert a checkbox there. In this instance, it’s cell B2. You can see the highlighted cell’s name in the Name box at the top-right corner of your screen below the toolbar.
Step 2: Click the Checkbox option.
In the main menu bar, click on Insert and select Checkbox. This would insert a checkbox in the highlighted cell.
You can now see the checkbox in your cell.
Step 3: Drag the checkbox to the other cells as well.
It’s unlikely that you need just one checkbox. You’ll find the fill handle present at the bottom-right corner of your highlighted cell.
Drag it to the desired cells. This would insert a checkbox in all those cells.
You can now check the box by clicking on it.
Changing the Default Value of the Checkboxes
There are values for these cells. Checkboxes are binary. Hence, they hold two values.
- Unchecked checkboxes hold the FALSE value
- Checked checkboxes hold the TRUE value.
These are the default values. While manipulating the sheet, we use these values.
If you don’t like the default values and want to customize them, you can do that too. Follow the below steps to customize the cell values.
Step 1: Highlight any cell with a checkbox.
Click on any cell with a checkbox.
Step 2: Select Data validation.
In the main menu bar, click on Data and select Data validation from the dropdown.
This will open the Data Validation dialog box.
Step 3: Enter custom values.
Check the Use custom cell values checkbox to enter custom values.
Now, you can see two text fields. Enter the custom values for checked and unchecked cells.
Step 4: Click Save.
Once you’re done, click the green Save button to save the changes made.
You can now see the custom values instead of the default TRUE or FALSE.
Inserting checkboxes in Google Sheets is a straightforward process. You can use the above methods to quickly insert a checkbox or customize the cell values.