What’s the matter with the function that cannot be achieved by pasting selectively in Excel?

#What’s the matter with the function that Paste Special cannot achieve in Excel?

There is no data copy operation in the content, so Paste Special in EXCEL is gray and cannot be used. The usage method is as follows:

Recommended: "excel tutorial"

1. Double-click the WPS version of the EXCEL table to open it.

2. After opening, select the data that needs to be copied, and hold down the CTRL C shortcut key on the keyboard to copy it. After the copy is successful, the border of the cell will appear blue. Colored dotted lines.

#3. Then move the mouse to the pasted cell, right-click, and click Paste Special.

#4. A selective sticky window will pop up, in which you can select the format you want to paste.

#5. After selecting, click OK and that’s it.

The above is the detailed content of What’s the matter with the function that cannot be achieved by pasting selectively in Excel?. For more information, please follow other related articles on the PHP Chinese website!