What should I do if the shape of the copy area is different in WPS?

#wps What should I do if the shape of the copy area is different?

Cause: There may be merged cells in the pasted area, causing errors when pasting.

Solution (take excel2016 as an example):

1. First select the data cells and copy them.

#2. Then switch to the location where you want to paste. You can see that there are merged cells at the pasting location.

#3. You can cancel the merged cells and then paste them or directly right-click the cells and select "Paste Special".

#4. Then click the "Keep source formatting" paste option.

#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.

The above is the detailed content of What should I do if the shape of the copy area is different in WPS?. For more information, please follow other related articles on the PHP Chinese website!