What to do if Excel cannot paste

Source: Internet
Author: User

1, first you look at the number of rows 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.

2, to determine whether your worksheet is locked in the state, if it is locked, is not pasted. The workaround is simple, just click one of them and unlock the state.

3, when you paste is a table selected? If yes, do not select a cell, but select multiple rows, note that the entire row, and then paste.

4, in addition to paste the source cell lock situation, the solution: right-set cell format-protection, there is a "lock" button, remove.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.