How to Copy, Paste, and Cut in WPS on macOS

Use Copy, Paste, and Cut in WPS on macOS through 6 how-to topics, all available directly in the spreadsheet editing interface; choose a topic from the index and follow the steps in order.

How-to Index

How-to Guide

1. Right-click Copy

Entry: Right-click menu → Copy

1. Select the cell you want to copy, or double-click a cell and select the text inside it.
2. Right-click to open the menu.
3. Select Copy.
4. When the selected area shows a moving border, the content has been copied to the clipboard.

Success Criteria

• On-screen result: the selected area shows a copy border.
• Next action available: you can paste the content into the current worksheet or another location.

Tips While Using

• Common mistake: if no cell or text is selected first, the Copy command may not be available.
• Environment note: if region permissions are enabled, the result may be limited by permission settings.

2. Copy as Picture

Entry: Right-click menu → Copy as Picture

1. Select the cell or cell range you want to copy.
2. Right-click to open the menu.
3. Select Copy as Picture.
4. Paste the result into a document, chat window, or presentation file and confirm that it appears as an image.

Success Criteria

• On-screen result: the copied result can be pasted into another app as an image object.
• Next action available: you can use the image in reports, instructions, or messages.

Tips While Using

• Common mistake: if you select only part of the text inside a cell, the result may not match the expected range image.

3. Copy as New Spreadsheet

Entry: Right-click menu → Copy as New Spreadsheet

1. Select the cell or cell range you want to copy.
2. Right-click to open the menu.
3. Select Copy as New Spreadsheet.
4. Wait for the new online spreadsheet to open and confirm that the selected content has been inserted there.

Success Criteria

• On-screen result: a new online spreadsheet page or window opens.
• Next action available: you can continue editing, sharing, or organizing data in the new sheet.

Tips While Using

• Common mistake: if you are not signed in or the network is unstable, the new online spreadsheet may not be created successfully.
• Environment note: this action works better with a stable network connection.

4. Right-click Cut

Entry: Right-click menu → Cut

1. Select the cell you want to move, or the text inside a cell that you want to move.
2. Right-click to open the menu.
3. Select Cut.
4. Paste the content into the target location. The original content is removed after the paste is completed.

Success Criteria

• On-screen result: the selected area shows a pending move border.
• Next action available: you can paste into the target cell to complete the move.

Tips While Using

• Common mistake: if you copy something else before pasting the cut content, the clipboard may be replaced.

5. Right-click Paste

Entry: Right-click menu → Paste

1. Complete a copy or cut action first.
2. Click the target cell.
3. Right-click to open the menu.
4. Select Paste.

Success Criteria

• On-screen result: the content appears in the target cell or target range.
• Next action available: you can continue editing, adjust formatting, or copy again.

Tips While Using

• Common mistake: if the target cell is not selected first, the pasted result may appear in an unexpected location.

6. Paste Special

Entry: Home tab → drop-down arrow next to Paste → Paste Special

1. Copy or cut the content you want to use.
2. Click the target cell.
3. On the Home tab, click the drop-down arrow next to Paste.
4. Select Paste Special.
5. Choose the result you need, such as values only, formatting only, or links.

Success Criteria

• On-screen result: only the selected paste result is applied to the target cell.
• Next action available: you can continue checking formulas, formatting, or links.

Tips While Using

• Common mistake: using standard paste directly may bring in formatting you do not want.
• Environment note: different paste types fit different kinds of data, so confirm the target result first.