Use Insert Checkbox in WPS on Android with 4 how-to topics, including inserting a cell checkbox and changing checkbox status; 4 items are available without membership and 0 items are membership-related.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Insert a checkbox in a cell | Free |
| 2 | 2. Change checkbox status | Free |
| 3 | 3. Set an entire column as checkboxes | Free |
| 4 | 4. Remove checkbox settings from a column | Free |
How-to Guide
1. Insert a checkbox in a cell
Entry: Bottom Insert tab → Checkbox
- Open the smart spreadsheet and select the target cell.
- Tap the Insert tab at the bottom.
- Tap Checkbox.
- A clickable checkbox is inserted into the current cell.
Success Criteria
- On-screen result: A checkbox appears in the selected cell.
- What you can do next: You can tap the checkbox to change its state or continue adding checkboxes to other cells.
Tips While Using
- Common mistake: If you do not select a cell first, it may be unclear where the checkbox will be inserted.
- Environment note: The smart spreadsheet must be in editable mode.
2. Change checkbox status
Entry: An inserted checkbox
- Find the checkbox that has already been inserted in the spreadsheet.
- Tap the checkbox.
- Switch between the checked and unchecked states.
Success Criteria
- On-screen result: The checkbox state changes.
- What you can do next: You can tap again to switch the state repeatedly.
Tips While Using
- Common mistake: If you tap the cell but not the checkbox itself, you may only select the cell.
- Environment note: In a collaborative sheet, status changes may need network access before other collaborators see the update.
3. Set an entire column as checkboxes
Entry: Column floating menu → More Actions → Column Type → Checkbox
- Open the smart spreadsheet and tap the target column header, such as A, B, or C.
- In the column floating menu, tap More Actions.
- Tap Column Type.
- In the column type list, select Checkbox.
- The whole column is set as a checkbox column.
Success Criteria
- On-screen result: The selected column is displayed as a checkbox column.
- What you can do next: You can manage checked states directly in that column.
Tips While Using
- Common mistake: If you tap a cell instead of the column header, the column floating menu will not open.
- Environment note: This requires a smart spreadsheet that supports column type settings.
4. Remove checkbox settings from a column
Entry: A column already set as checkboxes → Clear Column Type
- Select the column that has already been set as a checkbox column.
- Open the related column action menu.
- Select Clear Column Type.
- The column returns to a regular column display.
Success Criteria
- On-screen result: The column is no longer displayed as a checkbox column.
- What you can do next: You can set another column type or continue editing regular cell content.
Tips While Using
- Common mistake: If you select only one cell instead of the whole column, the column type may not be cleared.