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. Check out my online courses
Become an Affiliate and earn 25% on Course Sales
For more help visit my website or email me at easyexcelanswers@gmail.com.
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.
Check out my next one-hour Excel Webinar
I use a Blue condensor Microphone to record my videos, here is the link
Check out Crowdcast for creating your webinars
If you need to buy Office 2019 follow
I use Tube Buddy to help promote my videos
Check them out
Follow me on Facebook
TWEET THIS VIDEO
Follow me on twitter
easyexcelanswers
IG @barbhendersonconsulting
You can help and generate a translation to you own language
*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.
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
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.
Thank you so much,
Very tutorial indeed. Thank you very much
Thank you so much for this for video! I never knew it would take the merged title too while sorting.
Thanks you Barb. Very clearly presented.
Thank you! This worked
Great,it worked.Thank you
You are an angel. Saved me so much of frustration. THANK YOU!
Hi, what about if the cells I wanted to"fake" merge was 4 cells, like:
"cell" "cell"
"cell" "cell"
If that makes sense? I need it to "merge" both horizontally and vertically.
You're a life saver!
Life saver, thank you!
I appreciate, faced the same issue.
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.
life saver!
ripped only a few hairs out Thanks Barb seemed to do the trick!
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.
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……
Wow, you made it so easy! Thank you!
sadness from inside out teaching excel now
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)
Thankyouuuuu😘😘😘😘
Thank you!
Thanks teacher. ıt helped, i really appreciate your effort
thank you
I have same problem but in columns
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….