How

How to add a checkbox in Google Sheets

Checkboxes are handy for all kinds of situations, even for data you add to a spreadsheet. In Google Sheets, you can add checkboxes for things like project tasks, answers to questions, or select product attributes.

google sheets her 1200x675 - How to add a checkbox in Google Sheets

The nice thing about using a checkbox in Google Sheets is that you can also use data validation to set custom values. So if you want to use conditional formatting, for example, you can use checked or unchecked value to set up your rule.

Here we will show you how to insert a checkbox into Google Sheets and set custom values ​​as well.

How to insert a check box in Google Sheets

Visit Google Sheets, sign in, and open the sheet you want to use. Select the cell where you want the check box. Then click Insert > checkbox from the list.

InsertCheckbox GoogleSheetsCheckbox - How to add a checkbox in Google Sheets

And there you go. Your check box in the cell you selected is ready to be checked!

InsertedCheckbox GoogleSheetsCheckbox - How to add a checkbox in Google Sheets

If you want to add more checkboxes in adjacent cells, you can use the fill handle and drag your checkboxes across the remaining cells.

FillHandle GoogleSheetsCheckbox - How to add a checkbox in Google Sheets

To remove a checkbox you no longer need, simply select the cell and hit Delete on your keyboard.

Add custom values ​​to a checkbox

As mentioned earlier, you can set values ​​for your checkbox when it is checked and unchecked. Right click on the cell containing the checkbox and select “Data validation.

DataValidation GoogleSheetsCheckbox - How to add a checkbox in Google Sheets

When the window appears, choose “checkbox” in the Criteria drop-down box.

DataValidationCheckbox GoogleSheetsCheckbox - How to add a checkbox in Google Sheets

Next, check the box “Using custom cell values”. Then enter the values ​​of Verified and Unchecked. Click “save.

DataValidationValues ​​GoogleSheetsCheckbox - How to add a checkbox in Google Sheets

Now if you want to use the values ​​for something else in your sheet, like the conditional formatting mentioned earlier, you’ll have values ​​to work with for the checked and unchecked box.

Tip: If you want to add check boxes to adjacent cells using the same custom values, add the values ​​to the first check box, and then use the fill handle to drag the check box across the remaining cells.

Remove custom values ​​from checkbox

If you decide later that you no longer want the custom values ​​you set, removing them is simple. Right click on the cell containing the checkbox and select Data Validation just like you added the values.

Uncheck the Use custom cell values ​​box and click on “save. This allows you to keep your checkbox, but simply remove the custom values.

DataValidationRemoveValues ​​GoogleSheetsCheckbox - How to add a checkbox in Google Sheets

If you use Excel in addition to spreadsheets, take a look at how to use checkboxes to create a checklist in Microsoft Excel.

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button

Adblock Detected

Please consider supporting us by disabling your ad blocker