WPS Features
Resources
Free AI Tools
Docs Center

How to Move or Copy a Worksheet in WPS on macOS

Last updated:July 16, 2026

Use Move or Copy Worksheet with 4 how-to topics, all available without membership on macOS; choose a topic from the index to quickly move, copy, or transfer worksheets across workbooks.

How-to Index

No.TopicMembership Requirement
11. Move a worksheet from the sheet tab shortcut menuFree
22. Open Move or Copy Worksheet from the ribbonFree
33. Move a worksheet to another workbookFree
44. Copy a worksheet and keep the originalFree

How-to Guide

1. Move a worksheet from the sheet tab shortcut menu

Entry: Right-click a worksheet tab → Move

  1. Find the worksheet tab you want to reposition at the bottom of the workbook.
  2. Right-click the worksheet tab.
  3. Select the related move command from the menu.
  4. Choose the target position in the dialog or settings window.
  5. Click OK to finish moving the worksheet.

Success Criteria

  • Interface result: The worksheet tab appears in the new position.
  • What you can do next: You can continue editing the worksheet or adjust the order again.

Tips While Using

  • Common mistake: Moving the wrong sheet because the intended worksheet tab was not selected first.
  • Environment note: Open the destination workbook first if you want to move the worksheet to another workbook.

2. Open Move or Copy Worksheet from the ribbon

Entry: Home tab → Worksheet drop-down menu → Move or Copy Worksheet

  1. Open the workbook that contains the target worksheet.
  2. Click the Home tab.
  3. Open the Worksheet drop-down menu.
  4. Click Move or Copy Worksheet.
  5. Choose the target position in the dialog box and click OK.

Success Criteria

  • Interface result: The Move or Copy Worksheet dialog opens, and the worksheet position is updated after confirmation.
  • What you can do next: You can repeat the same process for other worksheets.

Tips While Using

  • Common mistake: Opening the menu without confirming the destination position, which can lead to an unexpected result.

3. Move a worksheet to another workbook

Entry: Move or Copy Worksheet dialog

  1. Open both the current workbook and the destination workbook.
  2. Select the worksheet you want to move.
  3. Open Move or Copy Worksheet from the sheet tab menu or the ribbon.
  4. Choose the destination workbook from the workbook list.
  5. Select the insertion position and click OK.

Success Criteria

  • Interface result: The worksheet appears in the destination workbook and is removed from the original workbook.
  • What you can do next: You can continue editing or save the destination workbook.

Tips While Using

  • Common mistake: The destination workbook does not appear in the list because it was not opened first.
  • Environment note: After a cross-workbook move, check formulas or references if the worksheet is linked to other sheets.

4. Copy a worksheet and keep the original

Entry: Move or Copy Worksheet dialog

  1. Select the worksheet you want to copy.
  2. Open the Move or Copy Worksheet dialog.
  3. Choose the destination workbook and insertion position for the copied sheet.
  4. Select the option that creates a copy.
  5. Click OK to generate the duplicate worksheet.

Success Criteria

  • Interface result: The original worksheet remains, and a new worksheet with the same content appears.
  • What you can do next: You can edit the duplicate independently without changing the original sheet.

Tips While Using

  • Common mistake: Forgetting to select the copy option, which turns the action into a move instead of a copy.
  • Environment note: The copied worksheet name may automatically include a number so you can distinguish it from the original.