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