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.
------------------------

[@runarorn90]

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

[@gchari2494]

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

[@lahopkins9746]

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! 🙏🏾

[@mercymwende370]

Your video is short and straight forward

[@BVET8677]

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

[@melhaer]

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

[@IvanCortinas_ES]

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

[@RyanKosterow]

New follower, thanks for the straight and simple answer!

[@MarcosSantos-yt7ds]

Many thanks buddy. Helps a lot here.

[@chascarpenter5006]

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

[@lydethful]

Simple and straight to the point

[@DrPawfection]

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

[@peiweihe7630]

Thanks bro. Your sharing is very useful and clear.

[@jonahparishioner6152]

wish I'd seen this years ago, thank you!

[@liammurphy4118]

Cheers. Crystal Clear ! thank you

[@JenniferDonow]

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

[@lucialondono7947]

Great!! very easy explanation!

[@vlasisvstrom]

Thank you so much!

[@benjaminasklivickas2357]

Thank you!

[@Josh-g8d]

DUDE EXCELLENT JOB!!! THANKS SO MUCH!!

[@mahediofficial7721]

Helping video. Than you bro

[@ChesterTugwell]

Happy to help

[@asadd7260]

Thank you Man. It helped me.

[@ceyhunkvrak7791]

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?

[@azzuralailaamalisy2506]

Its work, thanks :)

[@SPOROLIFE]

Genuis sorted my problem straight forward.

[@sarababiker6654]

Thank u very much ❤❤❤ i needed this

[@vivek7026]

excel can't sort because the sort range includes an autofiller
Please Help me Out

[@Thestrongmanphysiologist]

Amazing.

[@malikwijaya123]

Thanks.

[@ChesterTugwell]

You're welcome

[@allisoncolter5215]

Thank you! Solved my error!

[@CPTic19]

Love you

[@TheDoppelgangster]

Thank you! Thank you! Thank you!

[@lluviaagustin280]

Thank you. I fixed it.

[@YeakYol]

Thank you so much

[@sarveshbala4759]

so helpful

[@reekfarida8208]

🎉

[@dessalegnenegussie2963]

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.

[@thymusictoo364]

This helped me very much, thank you!!

[@925silverjewelry2]

thank you so much !

[@ChesterTugwell]

You're welcome!