How to Create Worksheet Copies in WPS on macOS

This how-to guide includes 3 worksheet copy topics on macOS, with 3 available without membership and 0 membership-related items.

How-to Index

How-to Guide

1. Create a copy from the shortcut menu

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

1. Open the spreadsheet file you want to edit.
2. In the worksheet tab bar, right-click the worksheet tab that you want to duplicate.
3. Click Create Worksheet Copy in the menu.
4. Check whether the new worksheet copy appears in the tab bar.

Success Criteria

• Interface result: A new worksheet copy appears in the tab bar.
• What you can do next: You can rename, edit, or move the copied sheet.
• No side effect: The original worksheet remains in place.

Tips While Using

• Common mistake: If you right-click outside the worksheet tab, the expected menu may not appear.
• Environment note: Open a spreadsheet file with visible worksheet tabs before starting.

2. Create a copy from the ribbon

Entry: Home → Worksheet menu → Create Worksheet Copy

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

Success Criteria

• Interface result: A new worksheet with the same content is added to the current workbook.
• What you can do next: You can continue editing data, formatting, and formulas in the copied sheet.
• No side effect: The original worksheet is not overwritten.

Tips While Using

• Common mistake: If the target worksheet is not selected first, you may copy the wrong sheet.
• Environment note: Depending on the interface layout, the worksheet command may appear inside a drop-down menu.

3. Create a copy by dragging a worksheet tab

Entry: Hold Ctrl and drag a worksheet tab

1. Open the spreadsheet file and locate the worksheet tab that you want to copy.
2. Hold down Ctrl.
3. Drag the worksheet tab to the target position.
4. Release the mouse to finish creating the copy.
5. Confirm that the copied sheet appears at the target position.

Success Criteria

• Interface result: A new worksheet appears in the tab bar at the target position.
• What you can do next: You can continue editing the copied sheet immediately in its new position.
• No side effect: The original worksheet remains available.

Tips While Using

• Common mistake: If you do not keep holding Ctrl, the action may move the sheet instead of copying it.
• Environment note: Make sure the worksheet tab is visible and draggable before you start.