How to Create a Worksheet Copy in WPS on Android

This how-to guide includes 3 topics, with 3 available without membership and 0 membership-related items; use the index below to jump to the task you need.

How-to Index

How-to Guide

1. Create a worksheet copy

Entry: Long-press a worksheet tab → Copy Worksheet

1. Open the spreadsheet file you want to work with.
2. Find the worksheet tab you want to copy at the bottom of the screen.
3. Long-press that worksheet tab.
4. Select Copy Worksheet from the pop-up menu.

Success Criteria

• Interface result: A new worksheet copy appears in the worksheet tab list.
• Next action available: You can switch to the new worksheet and continue viewing or editing it.

Tips While Using

• Common mistake: Make sure you long-press the worksheet tab instead of a cell area.
• Environment note: The file needs at least one visible worksheet tab.

2. Check whether the copied worksheet is complete

Entry: Open the newly created worksheet copy

1. Tap the new worksheet copy tab.
2. Check whether the cell content matches the original worksheet.
3. Check whether formulas, formatting, and comments are still present.

Success Criteria

• Interface result: The copied worksheet shows the same layout and data arrangement as the original.
• Next action available: You can continue entering, editing, or saving content in the copied worksheet.

Tips While Using

• Common mistake: Do not check only one area. Review the title area, data area, and note area together.

3. Edit the copied worksheet without affecting the original

Entry: Open the copied worksheet and edit directly

1. Open the worksheet copy you created.
2. Change cell content, formulas, or formatting in the copied worksheet.
3. Switch back to the original worksheet for comparison.
4. Confirm that the original worksheet has not changed.

Success Criteria

• Interface result: Your edits appear in the copied worksheet.
• Next action available: The original worksheet remains available for separate viewing and editing.
• No side effect: The original worksheet content stays unchanged.

Tips While Using

• Common mistake: Before editing, confirm that you are on the copied worksheet tab rather than the original tab.