In the above example, as soon as a box is checked in Column B, it changes the color of the corresponding item in column A, as well as applying the strikethrough format. Let me first show you what I plan to create.īelow is a to-do list that you may find a project manager use. Example 1 – How to Insert Checkbox in Google Sheets With Conditional Formatting to Make a To-Do List Let’s go through each of these examples in detail. You can download one of our Google Sheets checkbox templates below. Create Interactive charts in Google Sheets.Highlight specific data points based on selection (such as top/bottom 10).Create a to-do list and mark tasks as done/complete.This change in value in the cell means that we can do some really cool things with checkboxes in Google Sheets, such as: When the checkbox is unchecked, the cell value becomes FALSE.When the checkbox is checked, the cell value becomes TRUE.It works as a toggle – when you click on it once, it gets checked, and if you click on it again, it gets unchecked.īut the checkbox is what you see in the cell, in the backend, something else happens: Once you have inserted a checkbox in Google Sheets, you can use it by simply clicking on it.

You can also customize the cell values in the data validation window. Doing this will insert the checkbox in all the selected cells.Ĭheckboxes in Google Sheets are like texts in a cell which means that you can change their size, color, and even fonts, although they won’t look too different. If you want to insert the checkbox in more than one cell, select those cells and then insert the checkbox. The above steps would insert a checkbox in the selected cell. Select the cell in which you want to insert the checkbox.Here are the steps to insert a checkbox in Google Sheets: Can You Make the Checkboxes Behave Like Radio Buttons?.How Do I Make the Checkbox Green in Google Sheets?.Is There a Way to Uncheck All Boxes in Google Sheets?.

Can You Have Multiple Checkboxes in One Cell in Google Sheets?.How Do You Deselect a Box in Google Sheets?.How Do I Conditional Format a Checkbox in Google Sheets?.How to Insert Checkbox in Google Spreadsheet FAQ.How to Hide/Unhide data with Google Sheets Checkbox.Adding Checkboxes in Google Sheet on Android and iOS.Example 4: How To Add Google Sheets Checkbox with App Scripts.How to Remove Custom Values From a Checkbox.Using Data Validation to Add Custom Values to Checkboxes in Google Sheets.How to Add Checkboxes in Google Sheets With the Fill Handle.How to Check and Uncheck All Boxes In Google Sheets.Example 3 – How to Make Check Boxes in Google Sheets and Make an Interactive Chart.

Example 2 – Highlight Data Using Checkboxes and Conditional Formatting.

Example 1 – How to Insert Checkbox in Google Sheets With Conditional Formatting to Make a To-Do List.

How to add a check box in google sheets