I. Overview
Use checkboxes in a table, check completed items, and record tasks statuses. Want to complete 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
- 1.Add a checkbox
Method 1: Select one or more cells, and click the Checkbox button in the toolbar to add a checkbox in the cell. Click each small block to check or uncheck.
Method 2: Select multiple checkboxes to copy and paste them onto 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 "+".
- 2.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 Content or Clear All in the menu.
- 3.Modify the checkbox color
Select the cell that contains the checkbox and modify the cell text color. The checkbox color will be modified accordingly.
- 4.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:
- 1.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 table 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 customer order rate.
- 2.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.