How to Add or Remove Records in WPS Spreadsheet on Android

This guide includes 5 operation topics for adding records, inserting records, duplicating records, clearing records, and deleting records; 5 are available without membership and 0 are membership-related.

How-to Index

How-to Guide

1. Add a Record

Entry path: Bottom toolbar → Add Record → Confirm Add

1. Open the spreadsheet file that contains the data table.
2. Tap Add Record on the bottom toolbar.
3. Enter the field content you need in the pop-up window.
4. Tap Confirm Add to finish.

Success Criteria

• Interface result: A new record appears in the data table.
• What you can do next: You can continue editing the new record fields.

Tips While Using

• Common mistake: Confirming before entering the needed fields may require another edit afterward.

2. Insert a Record

Entry path: Select an existing record → Floating toolbar → Insert Above / Insert Below

1. Tap the row number on the far left of the target record to select it.
2. On the floating toolbar, tap Insert Above to add a new record above the current one.
3. Or tap Insert Below to add a new record below the current one.
4. Enter the required content in the new record.

Success Criteria

• Interface result: A new record appears above or below the target record.
• What you can do next: You can enter field content in the new record immediately.

Tips While Using

• Common mistake: If you do not select the record number first, the floating toolbar may not appear.

3. Duplicate an Existing Record

Entry path: Select an existing record → Floating toolbar → Duplicate

1. Tap the row number on the far left of the target record to select the record you want to copy.
2. Tap Duplicate on the floating toolbar.
3. Check the newly created copied record below the original one.
4. Edit the duplicated fields as needed.

Success Criteria

• Interface result: A similar record appears below the current record.
• What you can do next: You can continue editing the duplicated record.

Tips While Using

• Common mistake: Not reviewing copied field values may leave outdated information in the new record.

4. Clear a Record

Entry path: Select an existing record → Floating toolbar → Clear

1. Tap the row number on the far left of the target record to select it.
2. Tap Clear on the floating toolbar.
3. Check whether the current record content has been cleared.

Success Criteria

• Interface result: Clearable content in the current record is removed.
• What you can do next: You can enter new field content in the same position.

Tips While Using

• Common mistake: Confusing Clear with Delete.
• Environment note: System-filled content cannot be cleared.

5. Delete a Record

Entry path: Select an existing record → Floating toolbar → Delete

1. Tap the row number on the far left of the target record to select it.
2. Tap Delete on the floating toolbar.
3. Confirm that the current record has been removed from the data table.

Success Criteria

• Interface result: The current record disappears from the data table.
• What you can do next: You can continue organizing other records.

Tips While Using

• Common mistake: Deleting before confirming the target record may remove valid data by mistake.