How to Add or Delete Records in WPS on Android

Use Add/Delete Record through 5 how-to topics on Android smart spreadsheet data tables; all 5 topics are available without membership and can be opened from the index below.

How-to Index

How-to Guide

1. Add a Record

Entry path: Bottom toolbar → Add Record → Confirm Add

1. Tap Add Record on the bottom toolbar.
2. Enter the field content in the pop-up window.
3. Tap Confirm Add at the bottom to finish.

Success Criteria

• Interface result: A new record appears in the data table.
• Next action available: You can continue editing the fields in the new record.

Tips While Using

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

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. Tap Insert Above on the floating toolbar to add a new record above the current one.
3. Tap Insert Below on the floating toolbar to add a new record below the current one.

Success Criteria

• Interface result: A new record appears above or below the selected record.
• Next action available: You can edit the inserted record immediately.

Tips While Using

• Common mistake: If the target record is not selected first, the insert options 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 it.
2. Tap Duplicate on the floating toolbar.

Success Criteria

• Interface result: A similar new record is created below the current record.
• Next action available: You can edit the copied record and change only the needed fields.

Tips While Using

• Common mistake: Not checking the copied fields may leave old 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. The app clears the current record content; automatically filled content is not cleared.

Success Criteria

• Interface result: Clearable content in the current record is removed.
• Next action available: You can enter new field content in the same record.

Tips While Using

• Common mistake: Clear Record and Delete Record are different; after clearing, the record still stays in the table.

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 to remove the current record.

Success Criteria

• Interface result: The current record is removed from the data table.
• Next action available: You can continue organizing other records.

Tips While Using

• Common mistake: If you do not confirm the selected record first, you may remove the wrong one.