How to Use WPS Insert Checkbox on Windows

Use WPS Insert Checkbox on Windows through 3 how-to topics in WPS Sheets; 3 are available without membership and 0 are membership-related.

How-to Index

How-to Guide

1. Insert a Checkbox

Entry point: Insert tab → drop-down menu next to the Checkbox button

1. Select the cell where you want to add a checkbox.
2. Click the Insert tab.
3. Click the drop-down menu next to the Checkbox button.
4. Select Set Checkbox.

Success Criteria

• A checkbox appears in the selected cell.
• The checkbox can be checked and unchecked.

Tips While Using

• Select the target cell before opening the checkbox menu.
• If you are working in an online collaborative sheet, stay signed in to your account.

2. Clear a Checkbox

Entry point: Insert tab → drop-down menu next to the Checkbox button

1. Select the cell where you want to remove the checkbox.
2. Click the Insert tab.
3. Click the drop-down menu next to the Checkbox button.
4. Select Clear Checkbox.

Success Criteria

• The checkbox is removed from the target cell.
• The cell can be used like a regular content cell again.

Tips While Using

• Confirm the selected range before clearing checkboxes.
• For batch changes, review the selected column or area first.

3. Set a Column Type to Checkbox

Entry point: three-dot icon next to the column header → Column Type → Checkbox

1. Click the three-dot icon next to the target column header.
2. Select the Column Type menu.
3. Click Checkbox.
4. The cells in that column are then set to checkbox content.

Success Criteria

• The target column is displayed as a checkbox-type column.
• Cells in that column can be used for checked-state entry.

Tips While Using

• This works well when a full column needs a consistent yes/no style input.
• Check whether the column already contains content you want to keep before changing the type.