1、首先准备好你的两个excel文件。
![](https://iknow-pic.cdn.bcebos.com/77c6a7efce1b9d168263af36fcdeb48f8d5464c4?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、接下来将两个excel文件全部打开,这样excel才会识别两个文件,才能复制表单。
![](https://iknow-pic.cdn.bcebos.com/91529822720e0cf3e5e684ad0546f21fbe09aa57?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、接着进入到111的excel文件的界面,右击下边名称为sheet1的工作表,然后在弹出的菜单中选择移动或复制工作表选项。
![](https://iknow-pic.cdn.bcebos.com/a71ea8d3fd1f4134324530292a1f95cad1c85e72?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/8718367adab44aed2e238bb3bc1c8701a18bfb73?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、接着选择复制到的位置,一般不是最前就是最后,这里选择放在sheet1的前面,接着勾选下边的建立副本选项,不勾选就是移动,原有的文件中就没有了要复制的工作表。
![](https://iknow-pic.cdn.bcebos.com/d62a6059252dd42a6b6434fc0c3b5bb5c9eab873?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/6609c93d70cf3bc72c1806bade00baa1cd112a48?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)