Add a box from check on Google Sheets it can be too useful in a wide variety of situations, even for data that we add to any kind of spreadsheet. Google allows us to add these checkboxes for project tasks, answers to questions, selection of project attributes, etc. Let’s see a little below how we can do it step by step.
Add checkbox in Google Sheets
Let’s go to Google Sheets and we log in; once we do, we will have to open the spreadsheet that we want to use. Now we will have to select the cell where we want to place the check box. After this we are going to click on the Insert menu> Checkbox.
And voila, in this simple way we have already added a checkbox in a cell. We can add more adjacent checkboxes, we can do this with the fill handle and drag the checkboxes across the remaining cells.
In case we don’t want a box, then we simply select the cell in question and press Delete on our keyboard. The box will be removed.
Add custom values to a checkbox
We can add values to a checkbox when it is checked and unchecked. For this we will have to right click on the cell where the check box is located and select “Data validation”.
Next, a pop-up window will appear and we will have to select “Checkbox” in the drop-down box on the right side of “Criteria”.
Now we will have to check the box that says “Use custom cell values”. Then we will enter the values in the boxes and finally we will click on “Save”.
How to remove custom values
If we decide later that we want to remove those custom values. This is something simple, we right click on the box that has these values and select “Data validation”.
Next, we are going to have to uncheck the box “Use custom cell values” and then we click “Save”.
In this way we can keep the checkbox, we only delete the values that we have assigned to it.