How to solve the problem of different shapes of replication areas in wps

This article will explain in detail how to solve the problem of different shapes of replication areas in wps, and the content of the article is of high quality, so the editor will share it with you for reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

Reason: there may be merged cells in the pasted area, resulting in an error when pasting.

Solution (take excel2016 as an example):

1. First select the data cell and copy it.

2. Then switch to the location where you need to paste, and you can see that there are merged cells in the location where you want to paste.

3. You can cancel and paste the merged cell or right-click the cell directly and select "selective paste".

4. Then click the paste option of "keep in Source format".

5, you can paste the copied cells to the new cell location according to the original format, and you can directly overwrite the original merged cells.

On how to solve the problem of different shapes of wps replication areas to share here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.