How to Move and Copy Worksheets in WPS on Android

Use Move and Copy Worksheet with 2 how-to topics, including moving a worksheet and copying a worksheet; choose a topic from the How-to Index and follow the entry path and steps. Among them, 2 are available without membership and 0 are membership-related.

How-to Index

How-to Guide

1. Move a Worksheet

Entry: Press and hold a worksheet tab → Drag to move

1. Open the spreadsheet file where you want to change the worksheet order.
2. Press and hold the worksheet tab that you want to move.
3. Drag the worksheet tab to the target position in the tab bar.
4. Release your finger and confirm that the worksheet appears in the new position.

Success Criteria

• Interface result: The worksheet tab appears in a new order position.
• What you can do next: You can continue switching sheets or editing the current spreadsheet.

Tips While Using

• Common mistake: A short tap only switches worksheets, so press and hold before dragging.
• Environment note: If the file contains many worksheets, confirm the target tab area before dragging.

2. Copy a Worksheet

Entry: Tap a worksheet tab → Copy Worksheet

1. Open the spreadsheet file that contains the worksheet you want to copy.
2. Tap the target worksheet tab to open the related options.
3. Tap Copy Worksheet.
4. Check whether a copied sheet appears after the original worksheet.
5. Rename or edit the copied worksheet as needed.

Success Criteria

• Interface result: A new copied worksheet tab appears after the original worksheet.
• What you can do next: You can open the copy, edit it, rename it, or copy it again.
• No side effect: The original worksheet content remains unchanged.

Tips While Using

• Common mistake: After copying, confirm whether you are editing the original sheet or the copy.
• Environment note: The copied sheet name adds a number after the original name so multiple copies are easier to distinguish.