打开需要合并的excel表格
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/ca1349540923dd5425f8bbe3d709b3de9d8248b5?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
例如A列和B列是需要合并的列,我们在C列第一个单元格处写下公式=A1&B1,回车键结束,这时可以看见C1单元格的内容就是A1和B1的合并内容
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0823dd54564e9258a4809a659a82d158cdbf4e80?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/e7cd7b899e510fb3b8996b1cdf33c895d0430cbc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
把鼠标放在C1单元格右下角处,当鼠标变为十字型时往下拉,就可以批量的合并A列和B列的内容
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b21c8701a18b87d6c222b494010828381e30fddd?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
如果复制C列到其他表格会发现无法复制,那么怎么复制C列到其他表格 先选中C列需要复制的内容,点击鼠标右键,选中复制按钮,也可以直接按Ctrl+C复制
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/7e3e6709c93d70cfab0eb686fedcd100bba12b40?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
在想要表格处,先点击鼠标右键,在出现的选框中有个粘贴选项
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/f2deb48f8c5494ee948410922bf5e0fe98257e92?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
在粘贴选项中单击第二个标注有123的选项,即只复制数值,这样就可以复制了。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9922720e0cf3d7ca6a1a20fdf41fbe096a63a948?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)