How to Merge Cells in Excel (2026)
Want to make your Excel sheets look cleaner and more organized? In this video, I’ll show you how to merge cells in Excel using the "Merge & Center" feature—the perfect tool for creating professional-looking titles and headers.
I'll walk you through the different merging options, how to handle the "top-left value" warning, and how to unmerge cells if you change your mind. I also share a pro tip on when you should avoid merging cells to keep your data easy to sort and filter.
What you’ll learn in this video:
✅ The Basic Merge: How to use "Merge & Center" to create a main heading.
✅ Merge Options: The difference between Merge Across, Merge Cells, and Merge & Center.
✅ Handling Warnings: What happens to your data when you merge multiple cells with text.
✅ Unmerging: How to quickly split a merged cell back into its original parts.
✅ Formatting Tips: Why merging is great for titles but can be tricky for data tables.
Whether you're using Excel 365, Excel 2021, or an older version, these formatting tricks will help you design better spreadsheets in seconds.
If this quick Excel guide helped you design a better report, please Like the video and Subscribe for more search-based tech tutorials and productivity tips!