Impossible sorting excel

Hello.
The answer, unique and non-negotiable, to your question is IMPOSSIBLE.
... at least until Microsoft Office completely overhauls the design of its spreadsheet software.
It's not about agreeing or not; it's a fact: You also can't stick a stamp on an envelope contained within another already sealed envelope, can you?
--
Retirement is great! Especially in the Caribbean... :-)
☻ Raymond ♂

I managed to do it:

1. Copy and paste everything into TextEdit (I have a Mac - try WordPad on PC?)
2. Copy and paste everything into OpenOffice spreadsheet.

Hello everyone.
As for me, I arrived at this topic because I had the same problem, but I just found a solution.
To explain the context: I have a file to send with tables on the left and charts on the right. The table that was at the bottom of the page needed to have the same width as the ones above it, even though it had fewer columns. So, I had to merge some cells. For this table that changes every week, I added a button linked to a macro that sorts the data in descending order when clicked.
To successfully perform this sort despite the merged cells, I used a simple but effective trick:
I created another table that contains the values without merging.
The merged table simply points to the values of the other table.

For example: column A: unmerged title but I entered the formula: "=J5"
Columns B and C are merged but I entered the formula: "=K5"
Columns D and E are merged but I entered the formula: "=L5"

The sort is performed on the J;K;L table, and the display updates on the A;B;C;D;E table.

The J;K;L table is hidden behind one of the charts, but in your files, it could also be set to white font on a white background with no border to make it invisible.

Hoping to have helped you.