跳到主要內容

如何合併Excel中表格格式的區域中的單元格?

在Excel中,您可以使用Merge&Center實用程序輕鬆地將一些連續的單元合併為一個,如下圖所示。 但是,它不能合併在Excel中格式化為表格的範圍內的單元格,是否有任何技巧可以處理?
表1中的doc合併單元格

合併表格中的單元格

用Kutools for Excel合併相同的單元格好主意3


箭頭藍色右氣泡 合併表格中的單元格

在Excel中,無法合併表格中的單元格,但是在這裡,我介紹了一種a回技巧,可以讓您合併表格中的單元格。

選擇表格,轉到 設計 標籤,點擊 轉換為範圍,然後單擊 在彈出對話框中,將表格轉換為看起來也像表格的範圍。 看截圖:

表2中的doc合併單元格
表3中的doc合併單元格

 

然後選擇要合併的單元格,單擊 首頁 > 合併與中心,然後點擊 OK 在彈出的警告對話框中。 看截圖:

表4中的doc合併單元格
表5中的doc合併單元格

 

箭頭藍色右氣泡 用Kutools for Excel合併相同的單元格

如果要合併範圍內的相同單元格或取消合併範圍內的單元格,則可以應用 Excel的Kutools 合併相同的單元格 or 解除單元格.

Excel的Kutools, 與以上 300 方便的功能,使您的工作更加輕鬆。 
Comments (7)
No ratings yet. Be the first to rate!
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
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations