I. Intro

You can insert checkboxes into cells to mark items as complete and record task status. 

Note: For checkboxes, 0 indicates the checkbox is unselected and 1 indicates it is selected.

II. Steps

Add a checkbox

Method 1: Enter the spreadsheet, select one or more cells, and click Insert from the toolbar > Checkbox. Click the checkbox in the cell to select or deselect. You can also enter 0 (unselect) or 1 (select) in the cell to select or unselect the checkboxes. 

Method 2: Copy and paste checkboxes into other cells.

Method 3: Select a cell with a checkbox, hover over the lower right corner of the cell until your cursor changes to a + icon, then drag to add checkboxes to other cells. 

Delete a checkbox

Method 1: Select the cell that contains a checkbox and press Delete.

Method 2: Right-click the cell with the checkbox and select Clear > Clear Values or Clear All.

Change the checkbox color

Select the cell with the checkbox and modify the cell's font color. 

III. Use cases

Use checkboxes with the SUM function 

You can use the SUM function and checkboxes to get a percentage of the total. 

For example, you can enter =SUM(D18:D24)/7 to calculate the number of cells from D18 to D24 that are selected and then divide by the total number (7) to get the percentage of cells that are selected. 

Use checkboxes with the IF function 

Since 0 indicates a checkbox is unselected and 1 indicates it is selected, you can use the IF function to tally scores for a test.

For example, if the correct answer is option D, you can enter =IF(F2=1,1,0) in the cell, which will return a score of 1 if the checkbox in F2 is selected. 

Use checkboxes with the FILTER function 

Since 0 indicates a checkbox is unselected and 1 indicates it is selected, you can filter for completed tasks by filtering cells with a value of 1. 

IV. FAQs