What should I do if excel cannot copy and paste to another sheet?

What should I do if excel cannot be copied and pasted to another sheet?

This is because the two Excel processes are different. Open the task manager and you can see that there are two Excel processes.

Recommended: "Excel Tutorial"

##Cause:

1. Each file They all directly double-click the file to open it, sometimes resulting in dual processes.

2. The file is a protected view file.

Solution:

1. Close the file to be copied and open the file through the "File">>>"Open" command of the Excel file.

2. Click "Enable Editing" of the protected view file.

Solved by the above two methods, you can see from the task manager that there is only one Excel.exe process left.

Knowledge expansion:

The dual Excel processes are not only different in the selective paste dialog box, but also cannot automatically enter the referenced cell address when entering formulas. Therefore, you should try to use "File" when opening Excel. ">>> The "Open" command opens the file. If the source of the protected view file is reliable, editing should be enabled.

The above is the detailed content of What should I do if excel cannot copy and paste to another sheet?. For more information, please follow other related articles on the PHP Chinese website!