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?
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:
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.|
There are no comments posted here yet