WPS Sheets Insert Checkbox Feature User Guide

Feature Summary

Inserting a checkbox adds an interactive tick control in a cell, supporting state toggling and data-linked statistics, suitable for task lists, data collection, and similar scenarios.

Feature Description

Operation Steps

Insert Checkbox

Feature Entry
"Insert" tab → Dropdown menu next to the "Checkbox" button

1. Select the cell where you want to set the checkbox
2. Click the "Insert" tab
3. Click the dropdown menu next to the "Checkbox" button
4. Select the Set Checkbox button

Clear Checkbox

Feature Entry
"Insert" tab → Dropdown menu next to the "Checkbox" button

1. Select the cell where you want to clear the checkbox
2. Click the "Insert" tab
3. Click the dropdown menu next to the "Checkbox" button
4. Select the Clear Checkbox button

Set Cell Column Type to Checkbox

Feature Entry
Click the "…" icon next to the column header → "Column Type" dropdown menu → "Checkbox" option

1. Click the "…" icon next to the column header
2. Select the "Column Type" dropdown menu
3. Click the "Checkbox" option
4. After clicking, the entire column of cells will be set to checkbox content

FAQ

Question 1: What should I do if I cannot find the "Checkbox" button?

• Solution: WPS Online Spreadsheet supports direct insertion of checkboxes. Please ensure you are currently using an online spreadsheet.