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

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

藏色散人
藏色散人Original
2020-05-17 09:20:3437840browse

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.

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

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

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

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

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

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

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

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

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

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn