+3 votes
102 views
How to add Google Sheets checkbox

in Guides by (552k points)
reopened | 102 views

1 Answer

+4 votes
Best answer

Add checkbox in Google Sheets
Add custom values ​​to a checkbox
How to remove custom values

Add one box to check in Google Sheets can be very useful in a variety of situations, even for data that 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

image

We go to Google Sheets and 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.

image

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..

image

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

image

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"..

image

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".

image

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".

image

Next, we are going to have to uncheck the "Use custom cell values" box and then click "Save".

In this way we can keep the checkbox, we only delete the values ​​that we have assigned to it.



by (3.5m points)
edited

Related questions

+4 votes
1 answer
asked Apr 21, 2023 in Guides by backtothefuture (552k points) | 69 views
+5 votes
1 answer
asked Apr 18, 2023 in Guides by backtothefuture (552k points) | 68 views
+4 votes
1 answer
asked Nov 22, 2022 in Guides by backtothefuture (552k points) | 70 views
+4 votes
1 answer
asked Dec 31, 2021 in Guides by backtothefuture (552k points) | 109 views
+5 votes
1 answer
asked Jan 9, 2022 in Guides by backtothefuture (552k points) | 104 views
Sponsored articles cost $40 per post. You can contact us via Feedback

Most popular questions within the last 30 days

10,659 questions
10,791 answers
510 comments
3 users