This article explains how to merge and unmerge cells in Excel, and how to find a group of merged cells in a spreadsheet. The instructions in this article apply to Microsoft Excel 2019, 2016, and Excel in Microsoft 365.
Merge and Unmerge Cells in Microsoft Excel
Merging cells in Excel allows you to create a single larger cell that can span multiple rows and columns. This feature is useful when you need to create a text box or larger area to present your data. However, you may also need to unmerge your cells to change the design of your spreadsheet or perform certain data functions.
There are three separate methods to unmerge cells in Microsoft Excel. These methods are using the Excel ribbon, the Merge Cells menu, and using keyboard shortcuts. Each method is easy to use and makes formatting cells simple.
In Microsoft Excel, the ribbon is where you'll find most of the commands you use. The commands on this ribbon make it easy to merge and unmerge cells anywhere in an Excel spreadsheet.
