- To post as a guest, your comment is unpublished.· 10 months agoHi, 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.
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.|
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.