因为excel合并居中仅单元格水平居中，垂直方向不变。设置方法如下：
1、打开excel表格，在表格里面选中需要合并居中的单元格。
/iknow-pic.cdn.bcebos.com/d52a2834349b033bad0c986d1bce36d3d439bd85"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/d52a2834349b033bad0c986d1bce36d3d439bd85?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/d52a2834349b033bad0c986d1bce36d3d439bd85"/>
2、选中了之后点击工具栏上面的合并后居中选项。
/iknow-pic.cdn.bcebos.com/0df431adcbef76095efdfd2820dda3cc7dd99e96"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/0df431adcbef76095efdfd2820dda3cc7dd99e96?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/0df431adcbef76095efdfd2820dda3cc7dd99e96"/>
3、这样就可以将单元格合并了。
/iknow-pic.cdn.bcebos.com/0bd162d9f2d3572cd907f86b8413632763d0c3a4"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/0bd162d9f2d3572cd907f86b8413632763d0c3a4?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/0bd162d9f2d3572cd907f86b8413632763d0c3a4"/>
4、接着选中单元格里面的文字，对齐方式里面选择居中。
/iknow-pic.cdn.bcebos.com/a5c27d1ed21b0ef46e06fce9d3c451da80cb3e9e"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/a5c27d1ed21b0ef46e06fce9d3c451da80cb3e9e?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/a5c27d1ed21b0ef46e06fce9d3c451da80cb3e9e"/>
5、这样就可以将单元格合并居中，同时文字在中间了。
/iknow-pic.cdn.bcebos.com/9a504fc2d5628535cd2cb6969eef76c6a6ef63bc"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/9a504fc2d5628535cd2cb6969eef76c6a6ef63bc?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/9a504fc2d5628535cd2cb6969eef76c6a6ef63bc"/>
6、另外也可以选中单元格，右键单击鼠标，点击设置单元格格式进入。
/iknow-pic.cdn.bcebos.com/242dd42a2834349bf7370932c7ea15ce36d3be50"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/242dd42a2834349bf7370932c7ea15ce36d3be50?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/242dd42a2834349bf7370932c7ea15ce36d3be50"/>
7、进入到单元格格式设置界面之后，在对齐方式里面将水平对齐和垂直对齐都选择为居中，文本控制里面点击合并单元格，这样就可以了。
/iknow-pic.cdn.bcebos.com/0ff41bd5ad6eddc426cad34c37dbb6fd52663353"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/0ff41bd5ad6eddc426cad34c37dbb6fd52663353?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto"esrc="
https://iknow-pic.cdn.bcebos.com/0ff41bd5ad6eddc426cad34c37dbb6fd52663353"/>