How to Create Worksheet Copy in WPS on Windows

This how-to guide includes 3 operation topics for Create Worksheet Copy, covering right-click creation, ribbon creation, and Ctrl-drag creation; 3 items are available without membership and 0 items are membership-related.

How-to Index

How-to Guide

1. Create a copy from the right-click menu

Entry: Worksheet tab bar → right-click an existing worksheet tab → Create Copy

1. Open the spreadsheet file you want to work with.
2. On the worksheet tab bar at the bottom, right-click the worksheet tab you want to copy.
3. Click Create Copy in the shortcut menu.
4. Check whether the new worksheet copy appears in the tab bar.

Success Criteria

• Interface result: A new worksheet copy appears next to the original worksheet.
• What you can do next: You can switch to the copied worksheet and continue editing or rename it.
• No side effect: Changes to the copy do not affect the original worksheet.

Tips While Using

• Common mistake: Make sure you right-click the target worksheet tab instead of a cell area.
• Environment note: The current file needs visible worksheet tabs.

2. Create a copy from the ribbon

Entry: Home tab → Worksheet drop-down menu → Create Copy

1. Open the spreadsheet file and select the worksheet you want to copy.
2. Click the Home tab at the top.
3. Open the Worksheet drop-down menu.
4. Click Create Copy.
5. Confirm that the new copy has been created.

Success Criteria

• Interface result: A new tab appears with the same worksheet content.
• What you can do next: You can adjust the copied sheet position, name, or content.
• No side effect: The original worksheet remains in its original position.

Tips While Using

• Common mistake: Confirm that the active worksheet is the one you want to copy before you start.
• Environment note: In different interface layouts, the worksheet command may appear inside a drop-down menu.

3. Create a copy with Ctrl-drag

Entry: Hold down Ctrl and drag the worksheet tab

1. Open the spreadsheet file and find the target worksheet tab.
2. Hold down the Ctrl key.
3. Drag the worksheet tab to the target position with your mouse.
4. Release the mouse, then release Ctrl.
5. Confirm that a new worksheet copy appears in the target position.

Success Criteria

• Interface result: A new worksheet copy appears in the target position.
• What you can do next: You can copy and reorder the worksheet in one action.
• No side effect: The original worksheet remains in place, and the copy keeps the same content.

Tips While Using

• Common mistake: If you do not hold down Ctrl, you may move the worksheet instead of copying it.
• Environment note: Watch the tab position while dragging so you do not place the copy in the wrong location.