Enable Merged Cell Sorting
For rows or columns that contain merged cells, all rows or columns associated with the merged cells should be treated and sorted as 1 row or column.
Thank you for voting on “enable merged cell sorting”. While this is an interesting idea, we are not able to devote time to it in the near future. We’ll keep tracking the votes on this idea.
For example by telling Excel manually, "handle this two rows as one"
If we have a table with 5 columns of different formats and you merge one of the rows. How do you sort on column 2? The merged area has no column 2. Should it go above all other rows, below all others,????
What should happen if you merge the last cell on the first row and the 3 cells to it's right? Those cells aren't in the table, so must not move as a result of the sort. How do you move part of the merged area and not all of it?
Many many questions to be answered before it makes sense.
Finn Haverkamp commented
This would change my life. Merge Across works well, but still...
Corey Becker commented
As any advanced Excel user will tell you, the better solution is to stop merging cells. It leads to sloppy spreadsheets. There is always a better way to design your spreadsheet. Use Center Across Selection for horizontal text. If you have vertical text, you're doing it wrong.
Hyla Kooiman commented
Chris Schweiger commented
Looks intetesting! I say yes.