合并excel多个工作表的流程参考如下:
工具/原料:戴尔XPS13-9350-3708、win10、excel2019。
1、将鼠标光标移动到一个Excel文件图标上,双击鼠标左键打开文档。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/dbb44aed2e738bd45c2f944aae8b87d6277ff9bb?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、将鼠标光标移动到另一个Excel文件图标上,双击鼠标左键打开文档。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/72f082025aafa40f8478e8a6a464034f78f0190a?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、打开两个Excel文件后电脑任务栏并排显示了两个文件。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/c2fdfc039245d68879c995dfabc27d1ed31b2485?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、鼠标左键单击任意一个Excel文件WPS表格的下三角符号。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/3ac79f3df8dcd1001858df5a7d8b4710b8122f80?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、将鼠标光标移动到工具。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9e3df8dcd100baa16f8861c04810b912c8fc2e20?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、鼠标左键单击工具菜单下的选项。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/bd3eb13533fa828b2882bb98f21f4134970a5a23?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、鼠标左键单击在任务栏中显示所有窗口前的方框,把√去掉。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/dbb44aed2e738bd45ca8944aae8b87d6267ff9c4?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
8、鼠标左键单击确定。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/bd3eb13533fa828b28d2bb98f21f4134960a5ad3?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
9、得到两个工作表同时显示在Excel软件下。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9825bc315c6034a824779efac413495409237637?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)