WPS Sheets Copy, Paste, and Cut Feature Guide

Feature Summary

Copy, Paste, and Cut are the most basic data manipulation features in WPS Sheets. They support quickly moving and copying cell content and formatting. Combined with shortcut keys, they can significantly improve data processing efficiency.

Feature Description

Feature Dimension	Description
Membership Restriction	No membership restriction
Version Restriction	No version restriction

Operation Steps

Copy

Feature Entry
"Home" tab → "Copy" button

1. Select the cell or cell range you want to copy
2. Click the "Copy" button in the Home tab
3. A dashed selection box appears around the selected area, indicating the content has been copied to the clipboard

Copy as Picture

Feature Entry
"Home" tab → Dropdown arrow next to the "Copy" button → "Copy as Picture" button

1. Select the cell or text within the cell you want to copy
2. Click the arrow next to the Copy button in the Home tab
3. Click the "Copy as Picture" button in the pop-up dropdown menu
4. In the pop-up dialog box, select the picture format for copying, and click OK to complete the copy

Right-Click Menu Copy

Feature Entry
Right-click context menu → "Copy" button

1. Select the cell or text within the cell you want to copy
2. Right-click to bring up the context menu
3. Click the "Copy" button in the context menu
4. A dashed selection box appears around the selected area, indicating the content has been copied to the clipboard

Cut

Feature Entry
"Home" tab → "Cut" option

1. Select the cell or text within the cell you want to move
2. Click the "Cut" button in the Home tab
3. A dashed selection box appears around the selected area, indicating the content has been temporarily stored in the clipboard. After pasting, the content in the original cell will be deleted

Right-Click Menu Cut

Feature Entry
Right-click context menu → "Cut" button

1. Select the cell or text within the cell you want to move
2. Right-click to bring up the context menu
3. Click the "Cut" button in the context menu
4. A dashed selection box appears around the selected area, indicating the content has been temporarily stored in the clipboard. After pasting, the content in the original cell will be deleted

Paste

Feature Entry
"Home" tab → "Paste"

1. Click the target cell where you want to place the content
2. Click the "Paste" button in the Home tab
3. To cancel the operation, press the Esc key

Paste Special

Feature Entry
"Home" tab → Dropdown arrow next to the "Paste" button → "Paste Special" button

1. After copying or cutting content, click the target cell
2. Click the dropdown arrow next to the Paste button in the Home tab
3. Select "Paste Special", where you can choose options such as pasting values only, pasting formatting only, or pasting links

Right-Click Menu Paste

Feature Entry
Right-click context menu → "Paste" button

1. After copying or cutting content, click the target cell
2. Right-click to bring up the context menu
3. Click the "Paste" button in the context menu

In addition to the Paste button, you can also choose the "Paste Text Only" and "Paste Special" options

Copy Shortcut: Ctrl + C

Cut Shortcut: Ctrl + X

Paste Shortcut: Ctrl + V

FAQ

Question 1: How to quickly move cell content?

• Solution: After selecting a cell, hold down the mouse button and drag the cell border to the target position to move it directly; hold down Ctrl while dragging to quickly copy.

Question 2: How to cancel the copy/cut selection marquee?

• Solution: Press the Esc key to cancel the current copy or cut state.

Notes

• When copying, selecting an entire row/column may cause paste failure
• Copying while multiple worksheets are selected simultaneously may cause errors
• When worksheet and cell protection is enabled, paste operations may be restricted
• Using Paste Special can avoid format conflict issues