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

This how-to guide includes 6 operation topics for copy, paste, and cut in WPS Spreadsheet on Windows; all 6 are available without membership and 0 are membership-related.

How-to Index

How-to Guide

1. Right-click Copy

Entry point: Right-click menu → Copy

1. Select the cell or the text inside a cell that you want to copy.
2. Right-click to open the menu.
3. Click Copy.
4. When a moving border appears around the selected area, the content has been copied to the clipboard.

Success Criteria

• Interface result: A moving border appears around the selected range.
• What you can do next: Paste the copied content into another cell or another spreadsheet.

Tips While Using

• Common mistake: Opening the right-click menu before selecting the target cell or text.
• Environment note: If another app is heavily using the system clipboard, the result may not match your expectation.

2. Copy as Picture

Entry point: Right-click menu → Copy as Picture

1. Select the cell or range that you want to copy.
2. Right-click to open the menu.
3. Click Copy as Picture.
4. Paste the result into a chat window, document, or image tool to check the output.

Success Criteria

• Interface result: The pasted result appears as an image.
• What you can do next: Send, save, or insert the image into another file.

Tips While Using

• Common mistake: Selecting a very large range that becomes hard to read after pasting.
• Environment note: The target app needs to support image pasting.

3. Copy as New Spreadsheet

Entry point: Right-click menu → Copy as New Spreadsheet

1. Select the cell or range that you want to copy.
2. Right-click to open the menu.
3. Click Copy as New Spreadsheet.
4. Wait for the new online spreadsheet to open with the selected content.

Success Criteria

• Interface result: A new online spreadsheet opens and shows the copied data.
• What you can do next: Continue editing, sharing, or collaborating in the new spreadsheet.

Tips While Using

• Common mistake: Starting the action without a stable sign-in or network state.
• Environment note: This action is related to an online spreadsheet workflow, so a network connection is recommended.

4. Right-click Cut

Entry point: Right-click menu → Cut

1. Select the cell or the text inside a cell that you want to move.
2. Right-click to open the menu.
3. Click Cut.
4. Paste the content into the target location to complete the move.

Success Criteria

• Interface result: The original selection enters a cut-ready state.
• What you can do next: After pasting into the target cell, the original content is removed from its first location.

Tips While Using

• Common mistake: Copying something else before completing the paste, which may replace the clipboard content.
• Environment note: When cutting across apps, the target app needs to support the content type.

5. Right-click Paste

Entry point: Right-click menu → Paste

1. Copy or cut the content first.
2. Click the target cell.
3. Right-click to open the menu.
4. Click Paste to insert the content.

Success Criteria

• Interface result: The target cell shows the pasted content.
• What you can do next: Continue editing, formatting, or copying again.

Tips While Using

• Common mistake: Pasting into a range that already contains data and overwriting it.
• Environment note: Content from different sources may keep different formatting after paste.

6. Paste Special

Entry point: Home tab → Paste drop-down arrow → Paste Special

1. Copy or cut the content first.
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 paste type you need, such as values only, formatting only, or links.

Success Criteria

• Interface result: Only the selected content type is pasted into the target area.
• What you can do next: Check whether formulas, formatting, or links match your intended result.

Tips While Using

• Common mistake: Confirming the paste type too quickly without checking the option.
• Environment note: Available paste special options can vary depending on the copied source content.