How to merge cells in a range formatted as table in Excel?
In Excel, you can easily merge some consecutive cells into one with the Merge & Center utility as below screenshot shown. However, it cannot merge the cells in a range which formatted as a table in Excel, is there any trick to handle it?
Merge same cells with Kutools for Excel
Merge cells in a table
In Excel, there is no way that can merge cells in a table, but here I introduce a roundabout trick for you to merge cells in a table.
Select the table, the go to the Design tab, click Convert to Range, and then click Yes in the popping dialog to convert the table to a range which also looks like a table. See screenshot:
![]() |
![]() |
Then select the cells you want to merge, click Home > Merge & Center, and click OK in the popping out warning dialog. See screenshot:
![]() |
![]() |
Merge same cells with Kutools for Excel
If you want to merge same cells in a range or unmerge cells in a range, you can apply Kutools for Excel’s Merge Same Cells or Unmerge Cell.
Kutools for Excel, with more than 300 handy functions, makes your jobs easier. | ||
Sort comments by
![]()
#41235
This comment was minimized by the moderator on the site
0
0
![]()
#36597
This comment was minimized by the moderator on the site
0
0
![]()
#29594
This comment was minimized by the moderator on the site
0
0
![]()
#29595
This comment was minimized by the moderator on the site
Report
0
0
![]()
#20545
This comment was minimized by the moderator on the site
0
0
![]()
#19970
This comment was minimized by the moderator on the site
0
0
![]()
#19971
This comment was minimized by the moderator on the site
Report
0
0
There are no comments posted here yet
|