Sorting an Excel Table that contains Merged Cells. Ask Question 1. WHY do you have to used merged cells on this report? I personally can't think of any report that I've ever made that just COULD NOT be redone in a few different ways. Browse other questions tagged excel sorting merge or ask your own question. 7 years, 8 months ago.
Try it!Transcript
To extend content across multiple rows or columns in a table, merge cells to create a larger cell. Or, split cells into smaller cells.
Merge 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.
Split 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.
Want more?
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.