跳到主要内容

如何合并Excel中表格格式的区域中的单元格?

作者:孙 最后修改时间:2020-05-22

在Excel中,您可以使用Merge&Center实用程序轻松地将一些连续的单元合并为一个,如下图所示。 但是,它不能合并在Excel中格式化为表格的范围内的单元格,是否有任何技巧可以处理?
表1中的doc合并单元格

合并表格中的单元格

使用 Kutools for Excel 合并相同的单元格好主意3


箭头蓝色右气泡 合并表格中的单元格

在Excel中,无法合并表格中的单元格,但是在这里,我为您介绍了一种about回技巧,您可以合并表格中的单元格。

选择表格,转到 设计 标签,点击 转换为范围,然后单击 Premium Partner 在弹出对话框中,将表格转换为看起来也像表格的范围。 看截图:

表2中的doc合并单元格
表3中的doc合并单元格

 

然后选择要合并的单元格,单击 主页 > 合并与中心和点击 OK 在弹出的警告对话框中。 看截图:

表4中的doc合并单元格
表5中的doc合并单元格

 

箭头蓝色右气泡 使用 Kutools for Excel 合并相同的单元格

如果要合并范围内的相同单元格或取消合并范围内的单元格,则可以应用 Kutools for Excel 合并相同的单元格 or 解除单元格.

Kutools for Excel, 与超过 300 方便的功能,使您的工作更加轻松。 
Comments (8)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
Thank you. The pictures and guide are very helpful and understandable.
This comment was minimized by the moderator on the site
Thanks, Friend
Your suggestion about the merging table was very helpful.
This comment was minimized by the moderator on the site
graciaas. Me ayudaste un montón
This comment was minimized by the moderator on the site
Hi, I need combine Hello, I need to combine a range of two columns, but row by line, is there a formula or procedure to do it without having to go over it by line?
This comment was minimized by the moderator on the site
Hi, macro, do you want to column two columns as below screenshot shown? If so, you can use the formula =D1&E1, D1 and E1 is the cells in two column you want to combine, if not, please upload the file to display your desired result.
This comment was minimized by the moderator on the site
Great help! I was able to merge once I converted to range, best regards!
This comment was minimized by the moderator on the site
Hi i have tried Merge Same Cells With Kutools For Excel by downloading Kutools For Excel. But When I select two cells and click Kutools > Range > Merge Same Cells or Unmerge Cell, Its displaying a popup that ' This fuction can not be proceeded since: * The selection has table. Could you please help me how to overcome this
This comment was minimized by the moderator on the site
Hi, thank u for your message, I am sorry to tell you that the Merge Same Cells and Unmerge Cell utilities cannot apply in table, you can right click at the table, then click Table > Convert to range in the context menu to convert the table to range cells first, then apply the Merge Same Cells or Unmerge Cell utilties. Or you can copy the table and paste as value, then apply the utilities. Wish it is helpful.
There are no comments posted here yet
Leave your comments
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations