What to do if Excel cannot copy and paste

Excel cannot copy and paste how to do Excel is still the most popular form processing software, we have a lot of summary, financial and other work need to use, all kinds of formulas to make Excel more powerful, but, when we paste the data, often encounter: "Excel can not paste information, The reason for this is that the copy area is different from the paste area shape, so how do you solve the problem?

"What if Excel can't copy and paste?"

First look at the number of lines you are in, Excel2003 version of the maximum number of lines is 65536 lines. The maximum number of lines that Excel2007 starts is 1048576 lines, and if your data exceeds this limit, it's impossible to paste whatever you set it on.

Excel 2003 official version download address: http://www.duote.com/soft/7688.html

Excel 2007 official version download address: http://www.duote.com/soft/36009.html

Make sure your worksheet is locked, and if it's locked, it's not pasted. The workaround is simple, just click one of them and unlock the state.

Did you select a form when you pasted it? If yes, please see the next step.

Instead of selecting a cell, select more than one row, note that the entire row, and then paste.

In addition, paste the source cell lock case, the solution: right-set cell format-protection, where there is a "lock" button, remove.