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 cells in a table

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.