想要把两个excel表格合并成一个表格,可以按照以下步骤进行操作:
1、首先新建一个
Excel表格,根据实际情况从命名。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/1f178a82b9014a90a6e3d12fbb773912b21bee47?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/8b82b9014a90f603226d0bd52b12b31bb151ed47?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
3、然后点击数据。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b8014a90f603738dfb979bb0a11bb051f919ec47?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
4、点击合并计算,引入要合并的表格,浏览以后点击添加。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f703738da9773912e7fb12f3ea198618377ae247?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/a8773912b31bb051aef924ba247adab44bede047?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
【加入社群一起学习】想要了解更多关于excel的相关信息,推荐咨询秒可职场。秒可职场在不断提高员工工作能力的同时,也十分注重员工的精神文化活动,各项目定期开展
团建,开展员工生日会等活动,让员工感受到公司如家一般的温馨和亲人的关怀。提供公正、公开、公平的工作环境,充分尊重每一位员工的合理诉求,维护员工利益。