Getting around error message for sorting merged cells in Excel

Getting around sorting and filtering errors with merged cells in Excel.
Difficulty in Sorting and filtering merged cells can be fixed with this method. Center across selection. Free templates and templates with code are available for purchase for $50 USD
www.easyexcela...
For more help visit my website www.easyexcelan... or email me at [e-mail].
Contact me regarding customizing this template for your needs.
Excel one-on-one on-line training available. Email me to arrange.
I am able to provide online help on your computer at a reasonable rate.
www.amazon.com...
I use a Blue condenser Microphone to record my videos, here is the link
amzn.to/37gyyGa
Check out Crowdcast for creating your webinars
app.linkmink.c...
If you need to buy Office 2019 follow
amzn.to/2VX5dv8
I use Tube Buddy to help promote my videos
Check them out
www.Tubebuddy....
Follow me on Facebook
/ easyexcel.answers
TWEET THIS VIDEO • Getting around error m...
Follow me on twitter
easyexcelanswers
IG @barbhendersonconsulting
You can help and generate a translation to you own language
www.youtube.com...
*this description may contain affiliate links. When you click them, I may receive a small commission at no extra cost to you. I only recommend products and services that I've used or have experience with.

[@CR7UX]

Thank you so much, this issue is so specific that I was not thinking I would find a solution for it this easy. I really appreciate your time sharing your knowledge. This is my second time coming here because last semester I wanted to sort students' grades. and now I am back. Thank you.

[@rp-9866]

Thanks so much. I found I had to format the entire workbook, and not just the affected cells, but it worked magic and saved me a ton of time. (800 plus lines)

[@wernerb33]

Thank you so much! This really helps! This is probably the most irritating effect of a spreadsheet that was built by someone who doesn't actually understand Excel......

[@VickyVigneshwaran]

Hip Hip Hurray!!! you solved my problem....i must say you are such a genius .....thank you so much...expecting a lot more tutorials from u....

[@dawngunzenhauser4712]

I have merged cells that are extending into three columns. Is there a way to have the merged cells still be sorted AtoZ. I would be willing to send an email with my layout if you would like. I was unable to open your website. Thank you.

[@ligationtube]

You are an angel. Saved me so much of frustration. THANK YOU!

[@BarbHendersonconsulting]

Glad it helped!

[@danielserna2901]

ripped only a few hairs out Thanks Barb seemed to do the trick!

[@rinzi111]

Thank you so much for this for video! I never knew it would take the merged title too while sorting.

[@BarbHendersonconsulting]

Glad it was helpful!

[@patrickmoan6709]

Thanks you Barb. Very clearly presented.

[@BarbHendersonconsulting]

Glad you think so!

[@elise9338]

Wow, you made it so easy! Thank you!

[@chascarpenter5006]

Enjoyed your video, but, i cant find what data/info that is over hanging the box as i keep getting the message in the middle of the screen, is there a way of finding this as i have several thousand lines to look through, surely it can high light it, i'm used excell 98-2003 on windows 10, thank you.

[@DCsGladiator]

Amazing! Thank you so much for this. How are you doing nowadays?

[@BarbHendersonconsulting]

All good

[@denisagesa6499]

Very tutorial indeed. Thank you very much

[@BarbHendersonconsulting]

Glad it was helpful!

[@UPSTATE750]

Barb, this is exactly what I was looking for. Thank you for a wonderful and easy explanation. Subscribed and liked 🤝🫡

[@BarbHendersonconsulting]

Glad it was helpful!

[@francocolomba]

You're a life saver!

[@BarbHendersonconsulting]

Glad it helped

[@ahmedsamir-sm4bg]

Thank you so much,

[@BarbHendersonconsulting]

Welcome 😊

[@khaliilyasin4641]

Thanks teacher. ıt helped, i really appreciate your effort

[@garnet7017]

THANK YOU

[@BarbHendersonconsulting]

Happy to help!

[@inko123]

Life saver, thank you!

[@BarbHendersonconsulting]

Glad it helped!

[@TheExplained]

I appreciate, faced the same issue.

[@BarbHendersonconsulting]

Thanks

[@sevumyants]

Great,it worked.Thank you

[@BarbHendersonconsulting]

Welcome 👍

[@chasengonzales85]

Thank you! This worked

[@BarbHendersonconsulting]

Glad it helped!

[@xzayviyo]

Perfect

[@BarbHendersonconsulting]

thanks

[@brindasaivloginmixedlifest6520]

TQ mem ❤

[@BarbHendersonconsulting]

thanks

[@RohitKumar-tk1lh]

I have same problem but in columns

[@justinstuart9584]

Thank you!

[@jenniferabarca9890]

life saver!

[@BarbHendersonconsulting]

I figured it out because the problem was driving me insane!

[@AlexJohnson-kw2er]

thank you

[@shareliesmangrey2799]

Thankyouuuuu😘😘😘😘

[@webuser5950]

sadness from inside out teaching excel now