What to do if excel prompts that data cannot be pasted

What to do if excel prompts that data cannot be pasted

1. First look at the number of rows you are currently in. The maximum number of rows in Excel 2003 version is 65536 lines. The maximum number of rows in versions starting with Excel 2007 is 1,048,576 rows. If your data exceeds this limit, it will be impossible to paste it no matter how you set it.

Recommended study: "excel basic tutorial"

2. Make sure all your worksheets are locked. If It is locked and cannot be pasted. The solution is simple, just click on one of them to unlock the status.

3. Did you select a table when pasting? If so, please see the next step.

4. Do not select a cell, but select multiple rows. Pay attention to the entire row, and then paste.

5. In addition, there is a situation where the pasted source cell is locked. The solution: right-click-Format Cell-Protect, there There is a "lock" button, remove it.

For more related tutorials, please pay attention to PHP Chinese website!

The above is the detailed content of What to do if excel prompts that data cannot be pasted. For more information, please follow other related articles on the PHP Chinese website!