openpyxl合并单元格并写入数据_当EXCEL标题行跨列居中，合并单元格无法移动数据列如何解决...

 -点击本公众号   置顶星标公众号

对Excel批量操作，提升你的工作效率提升8倍以上(一))

EXCEL如何按指定要求提取多行内容重复数据内容

今天分享一下EXCEL标题行跨列居中，解决合并单元格无法移动数据列如何解决的几个技巧。

一、首先请看范例图片，在下面的数据表中，我们如果要合并首行标题，一般都会通过合并单元格作。

Remember when I had to chase you with thousand excuses I invented， in order that you wanted to bath… When you see my ignorance on new technologies… give me the necessary t

ime and not look at me with your mocking smile… I taught you how to do so many things… to eat good， to

dress well… to confront life… When at some moment I lose the memory or the thread of our conversation… let me 45have the necessary time to remember… and if I cannot do it， do not become nervous…　 as the most important thing is not my conversation but surely to be with you and to have you listening to me…

Remember when I had to chase you with thousand excuses I invented， in order that you wanted to bath… When you see my ignorance on new technologies… give me the necessary t

ime and not look at me with your mocking smile… I taught you how to do so many things… to eat good， to

dress well… to confront life… When at some moment I lose the memory or the thread of our conversation… let me 45have the necessary time to remember… and if I cannot do it， do not become nervous…　 as the most important thing is not my conversation but surely to be with you and to have you listening to me…

1、具体操作如下，选中首行点击【合并单元格】就可以实现首行标题合并。

2、这样会使得我们在移动数据列时出现错误提示：无法对合并单元格执行操作。

3、我们就要用另外一种方式来制作首行标题。选中首行，点击设置单元格格式符号。

4、在【对齐】中的水平对齐中选择【跨列居中】后点击确定。

5、首行标题制作完毕，我不可以们y对数据列操作时就可以完成需要的指定操作了。

以上就是合并单元格无法移动数据列的方法。今天就介绍到这里，如果觉得本公众号文章对你有学习工作有帮助的话，希望大家帮忙点赞点在看、点分享哦，关注本公众号，谢谢！

办公室最常用Excel函数公式大全，学会了工作得心应手

Excel表格如何计算特定数值范围个数

如何制作Excel下拉菜单，技巧全在这里