To extend content across multiple rows or columns in a table, merge cells to create a larger cell. Or, split cells into smaller cells.
Select the cells that you want to merge.
Select Layout > Merge Cells.
To unmerge cells, select the cells and select Unmerge Cells.
Note: In Excel, select the cells you want and select Merge & Center. To unmerge cells, select the cells and select Unmerge Cells.
Select the cell that you want to split.
Select Layout > Split Cells.
Enter the number of columns or rows that you want to split the selected cell into, and then select OK.
You can merge or split table cells however you’d like, to better organize your table.
For example, to make Monthly Sales the header for all of the months rather than for a single column.
Select the cells you want to combine.
Select Layout, and then Merge Cells.
And center the heading, Monthly Sales.
To add a quarterly sales heading, select the header row, and then select Split Cells.
To have a column for quarter 1 and one for quarter 2, leave the number of columns as 2 and select OK.
And add your header text: "Q1 Sales" and "Q2 Sales"
In Excel, you can’t merge cells in tables, but you can in spreadsheets.
To make Monthly Sales the header for all of the months, select the cells you want to merge, and then in Home, select Merge & Center. When you merge cells, you lose any data in the second cell.
To unmerge them, select Unmerge Cells.