在“开始”选项卡下,在工具栏找到"合并居中"按钮,并点击,即可达到合并单元格的效果,以下是具体的操作方法。
1、首先,打开需要操作的Excel表格。
/iknow-pic.cdn.bcebos.com/0ff41bd5ad6eddc416ff035237dbb6fd5266337a"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/0ff41bd5ad6eddc416ff035237dbb6fd5266337a?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/0ff41bd5ad6eddc416ff035237dbb6fd5266337a"/>
2、在合并单元格之前需要选择需要合并的单元格区域。
/iknow-pic.cdn.bcebos.com/738b4710b912c8fcfa854164f2039245d6882120"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/738b4710b912c8fcfa854164f2039245d6882120?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/738b4710b912c8fcfa854164f2039245d6882120"/>
3、使用快捷命令CTRL+M即可快速合并单元格。
/iknow-pic.cdn.bcebos.com/f7246b600c33874451c898d55f0fd9f9d72aa00e"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/f7246b600c33874451c898d55f0fd9f9d72aa00e?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/f7246b600c33874451c898d55f0fd9f9d72aa00e"/>
4、然后在选择一个其它区域进行合并。
/iknow-pic.cdn.bcebos.com/1c950a7b02087bf499e4e040fcd3572c11dfcf0b"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/1c950a7b02087bf499e4e040fcd3572c11dfcf0b?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/1c950a7b02087bf499e4e040fcd3572c11dfcf0b"/>
5、按下F4键同样可以快速合并。
/iknow-pic.cdn.bcebos.com/f11f3a292df5e0fe91443ea8526034a85edf723e"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/f11f3a292df5e0fe91443ea8526034a85edf723e?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/f11f3a292df5e0fe91443ea8526034a85edf723e"/>
6、在开始菜单中的功能区,通过框选合并区域后,在开始菜单功能区中点合并单元格,也能将单元格快速合并。
/iknow-pic.cdn.bcebos.com/35a85edf8db1cb13462c8bbad354564e93584bd5"target="_blank"title="点击查看大图"class="ikqb_img_alink">/iknow-pic.cdn.bcebos.com/35a85edf8db1cb13462c8bbad354564e93584bd5?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/35a85edf8db1cb13462c8bbad354564e93584bd5"/>