How to Merge Cells in Excel (Without Losing Data)

Merging cells in Excel seems simple… until it breaks your spreadsheet. In this video, I show you exactly how Merge and Center works, and why it can cause serious problems when sorting, filtering, or analyzing data. Host: Kevin Stratvert ? RESOURCES - Sample data to follow along: https://1drv.ms/x/c/b09f9559f6a16b6c/IQATsLLh3H4vTIYeuLgIFBWbAUezSDXTYQoJ6-MtTIQGFEA?e=szCrMl ⌚ TIMESTAMPS 0:00 - Introduction 0:00 - Merge cells using Merge and Center 1:11 - Explore Merge dropdown options 3:03 - Why merged cells break sorting 5:21 - Combine cells using formulas 7:29 - Wrap up ? RELATED VIDEOS - Playlist with all my videos on Excel: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY ? NEWSLETTER - Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://newsletter.kevinstratvert.com ? CONNECT WITH ME - Official website: http://www.kevinstratvert.com - LinkedIn: https://www.linkedin.com/in/kevinstratvert/ - Discord: https://bit.ly/KevinStratvertDiscord - Twitter: https://twitter.com/kevstrat - Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818 - TikTok: https://www.tiktok.com/@kevinstratvert - Instagram: https://www.instagram.com/kevinstratvert/ ? PARTNERS & DISCOUNTED OFFERS ? Hostinger | https://hostinger.kevinstratvert.com ? Notion | https://notion.kevinstratvert.com ? Quickbooks Online | https://qbo.kevinstratvert.com ?️ Voicemod AI Voice Changer | https://voicemod.kevinstratvert.com ?️ VidIQ | http://vidiq.kevinstratvert.com ? MY COURSES - Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/ ? REQUEST VIDEOS https://forms.gle/BDrTNUoxheEoMLGt5 ? SUBSCRIBE ON YOUTUBE https://www.youtube.com/user/kevlers?sub_confirmation=1 ? SUPPORT THE CHANNEL - Hit the THANKS button in any video! - Amazon affiliate link: https://amzn.to/3kCP2yz ⚖ DISCLOSURE Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same. #stratvert #excel