How to Merge Cells in Excel (Without Losing Data)

Save to stack
Kevin Stratvert Open on YouTube ↗
Excel for Analysts Use Case Advanced Excel Tricks Use Case Complete Beginners Audience Beginner Level Course Format AI for Business Use Case
From the creator

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

Choose to Build with AI
Matched to Excel for Analysts

AI Maker Residence 3

The third AI workshop taught by our legendary teacher, Nick Sarafa. This is a full-day hands-on training workshop for purposeful co-creation with AI using Claude Code. Imagine having access to hundreds of billions of dollars of computing power and knowing exactly how to make it work for you through the power of super intelligence.

◆ Fri 09 Oct 2026 ◆ KOKO Cafe, London ◆ With Nick Sarafa
Get your seat See every event
AI Maker Residence 3
Live event
AI Maker Residence 3
Fri 09 Oct 2026

More like this

Running one yourself?

List your AI event,
wherever it is.

A meetup, a workshop, a hackathon, a conference. Any city, or online. Tell us about it and it lands in front of people already learning this stuff.

List your AI event