1、打开我们需要复制数据的excel表格,如果复制到其他excel的工作表中,则同时打开两个文件。复制到同一excel表,直接点击切换。
![](https://iknow-pic.cdn.bcebos.com/f9198618367adab46e4cf54284d4b31c8701e417?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、如图所示,打开需要复制的内容,利用鼠标拖动,选定所有需要复制的数据内容。
![](https://iknow-pic.cdn.bcebos.com/a1ec08fa513d26971153e65c5afbb2fb4316d82b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、如下图红色箭头所示,在选定的区域内,右击,在弹出的菜单内选择“复制”。
![](https://iknow-pic.cdn.bcebos.com/d31b0ef41bd5ad6e31798aeb8ecb39dbb6fd3c2b?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、找到新的需要复制到的表格,鼠标单击粘贴文字的第一个表格。(呈现绿色边框)。
![](https://iknow-pic.cdn.bcebos.com/6609c93d70cf3bc74a4124edde00baa1cd112a6a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、在绿色边框内,右击鼠标,在弹出的菜单栏内选择“粘贴”选项。
![](https://iknow-pic.cdn.bcebos.com/a9d3fd1f4134970afa31f92e9acad1c8a7865d75?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、我们可以看到我们的新的工作表中出现了我们复制的表格内容了。操作完成。
![](https://iknow-pic.cdn.bcebos.com/8b82b9014a90f603690975463612b31bb051ed72?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)