Checkboxes come in handy for all types of situations, yes, even for data you add to a spreadsheet. In Google Sheets, you have the ability to add checkboxes for things like project tasks, answers to questions. OR. Selecting product attributes.
The thing about using a checkbox in Google Sheets is that you can also get to use data validation to assign custom values. In this article, we will show you how to insert a checkbox in Google Sheets.
How can you insert a Checkbox in Google Sheets?
- Go to Google Sheets, sign in, then open the sheet you want. Select the cell where you want to place the checkbox. Click on Insert > Checkbox.
- And that’s it: there will be a checkbox in the cell you selected, and it is ready to be checked.
- You can use the fill handle to drag the checkboxes through adjacent cells, after which you may utilize the arrow keys with your mouse.
- To remove a checkbox, select the cell, then press Delete on your keyboard.
How can you Add Custom Values to a Checkbox?
- You can assign values to your checkbox if it’s checked/unchecked. Right-click the cell containing the checkbox, then click on “Data Validation.”
- After the window opens, click on “Checkbox” in the Criteria drop-down.
- Check the box of “Use Custom Cell Values.” Then enter the values for Checked/Unchecked. Click on “Save.”
- If you want to use the values in your sheet, for example, the conditional formatting mentioned earlier, you will have values to work with for your checked/unchecked box.
How can you Remove Custom Values from a Checkbox?
- Right-click the cell containing the checkbox, then click on “Data Validation”
- Uncheck the box to Use Custom Cell Values, then click on “Save.” This allows you to keep your checkbox while removing the assigned values.
If you liked this article (or if it helped at all), leave a comment below or share it with friends, so they can also know How to Add a Checkbox in Google Sheets?