I. Overview

You can insert checkboxes into cells to check completed items, and record task status. Want to mark your to-dos? Check the box!

With a combination of checkbox and filter features, you can quickly find your completed tasks.

Note: In the checkbox rules, "0" represents not checked and "1" represents checked.

II. Procedures

•Add a checkbox

Method 1: Select one or more cells, and click the Checkbox button in the toolbar to add a checkbox into the cell. Click each small block to check or uncheck.

Method 2: Copy and paste checkboxes into other cells.

Method 3: Select a cell with an existing checkbox, hover the cursor over the lower right corner of the cell, press and hold, and drag it to add checkboxes in batches once the cursor changes to "+."

•Delete a checkbox

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

Method 2: Select the cell that contains the checkbox, right-click on it, and select Clear > Clear values or Clear all in the menu.

•Modify the checkbox color

Select the cell that contains the checkbox and modify the cell's text color. The checkbox color will be modified accordingly.

•Keyboard actions

Want to quickly check or uncheck? Try to enter 1 (check) or 0 (uncheck) in the cell with an existing checkbox.

III. Scenarios and practices

Checkboxes can be used in function calculations. Try the following 2 scenarios and use checkboxes in your table functions:

•Checkbox + SUM function = Efficient calculation of percentages

Cleverly match a checkbox with the SUM function to quickly calculate percentages. This is a must-have for sales personnel. For example, enter the function: =SUM(C2:C11)/10 in the sheet below.

Calculate the number of checked cells from C2 to C11 (number of people placing orders) and divide the number by 10 (total number of customers), to obtain the Sales closing ratio.

•Checkbox + IF function = Magnificent scoring tool

In the checkbox rules, "0" represents not checked and "1" represents checked. We can combine checkboxes with the IF function to make an electronic multiple choice question test.

This is a must-have for teachers grading exams. For example, the correct answer should be Option D in the following question. Then enter the function in the scoring cell: =IF(E4=1,1,0).

It means that if the F2 cell is checked, 1 point will be given for this question; and if the F2 cell isn't checked, 0 points will be given.

IV. FAQs

Can I enter content in a cell with a checkbox?

You can't enter other content for a cell with a checkbox. If you enter other content, an error will be prompted as a red mark in the upper right corner.