还是选中需要的单元格(包括合并的列),点击“合并后居中”,将把合并的单元格拆散。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/b3b7d0a20cf431ad005ced244736acaf2edd9825?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
然后在按照前面的步骤填充序列。填充好了之后,需要把原有合并的单元格,重新合并。依旧在Excel菜单栏点击“开始”,在“编辑”栏目下找到“排序和筛选”并点击“筛选”
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/9825bc315c6034a8ab11169cc713495409237638?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
点击筛选之后,会在Excel表头的位置,出现一排下拉选择框(黑色的倒三角),点击后,在文本框中输入可以囊括所有项目名称的通用字符,因我的名称里面都带有项目两个自,所以我这里填入“项目”。
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/024f78f0f736afc3289b9178bf19ebc4b7451213?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/f9198618367adab42d53b55e87d4b31c8701e428?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)