Fix Excel Error When Sorting: 'To do this, all the merged cells need to be the same size.'

This video demonstrates how to solve the "To do this, all the merged cells need to be the same size." error when trying to sort data in Microsoft Excel.
------------------------

[runarorn]

No unnecessary complications, problem solved in two minuets, perfect :)

[lahopkins]

Thank you so much! I've taken a couple Excel training courses, but I do not use it often, if at all, and 99% of what I know I've forgotten. 😁 I knew there was a way to do what I needed to do and you've explained perfectly. Appreciate you! 🙏🏾

[melhaer]

Thanks, helped me to sort correctly! Just unmerged all columns, then deleted all empty...and...the magic happened:)

[gchari]

Just wanted to say many thanks for your online page on how to clear used ranges in order to insert new cells. Best wishes.

[BVET]

Thank you so much. Took me hours of searching but your video helped me fix it in minutes

[IvanCortinas_ES]

Thanks Chester. Usually combining cells and having empty columns cause quite a few problems. Very good explanation.

[ovihwwe]

New follower, thanks for the straight and simple answer!

[DrPawfection]

Thanks that was great just what I needed re merged cells.

[chascarpenter]

Thank you for the good explanation. Sorting & merge cells in excel sorted.

[thymusictoo]

This helped me very much, thank you!!

[peiweihe]

Thanks bro. Your sharing is very useful and clear.

[JenniferDonow]

OMG, I wasted so much time and you helped me in 1 minute!

[mercymwende]

Your video is short and straight forward

[SPOROLIFE]

Genuis sorted my problem straight forward.

[ceyhunkvrak]

In the reports from the program, the numbers come in the form of text. I'm using the convert text to columns function to be able to convert these numbers from text to numbers without Excel freezing. But this only works when I select a single column. It gives a warning when I select more than one. Is there a solution to this problem?

[vivek]

excel can't sort because the sort range includes an autofiller




Please Help me Out

[dessalegnenegussie]

In my opinion Microsoft can do better. They know what people want to do and they have to make it work. right? Microsoft and Adobe products are notorious in instructions. Yes I mean that because you can't do something easily. You have to go up, down and then sideways to do simple stuff. And then imagine the time wasted to learn that simple command☹I would rather go to Google docs. Thanks anyways.