1、假设需要把3月1日到3月10日的数据合并起来汇总,打开电脑数据盘。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/8cb1cb134954092364528cc89c58d109b3de4949?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
2、新建空白文件夹,然后把合并的表格放置在这个文件夹中。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/3ac79f3df8dcd100666f14977c8b4710b8122f91?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/0b46f21fbe096b63a832b1e602338744ebf8ac59?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、点击excel表格中数据—>合并表格—>多个工作表合并成一个工作表。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/14ce36d3d539b6004907e001e750352ac75cb7bf?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
5、点击添加文件,把需要合并的excel数据表添加到文件中。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f703738da9773912ac906bd7f6198618377ae2d6?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
6、完成上一步后,取消勾选新建的excel表,并在左下方的选项中点击,选择表格标题的行数为1,然后点击开始合并。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/09fa513d269759ee77ac8e7dbcfb43166c22df8c?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
7、完成后,在新的excel表中,会出现两个工作簿,其中一个是合并的报告,显示数据合并成功与否,另外一个是合并后的工作簿。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/d62a6059252dd42a41ffef1d0d3b5bb5c8eab896?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)