The instructions in this article apply to Microsoft Excel 2019, 2016, and Excel in Microsoft 365.
There are three separate methods for unmerging cells in Microsoft Excel.
Each method is simple to use and makes formatting cells easy to do.
All other data in additional cells that are merged will be deleted after the merge.
Select thecellsyou want to merge or unmerge.
Go to theAlignmentsection and select theMerge and Centerdown arrow.
Select one of the merge options orUnmerge Cells.
If the highlighted cells are not merged, they will be.
If they are merged, the cells will be unmerged.
Highlight the cells you want to merge or unmerge.
Right-poke the selected cells and selectFormat Cells.
Select or deselect theMerge Cellsoption.
opt for cells you want to merge.
Press theAltkey on the keyboard to reveal shortcuts.
Tap theHkey to enter the Home ribbon.
Tap theMkey to initiate the Merge Cells menu.
Press theUkey to Unmerge the cells.
so you can find merged cells with ease, follow these simple steps.
From theHometab, selectFind & Select>Find.
In theFind and Replacedialog box that opens, selectOptions.
The Find and Replace dialog box expands.
Select theFormatdrop-down menu, then selectFormat.
SelectAlignment>Merge Cells>OK.
SelectFind Allto view all of the merged cells in your spreadsheet.
you’re able to select each item in the list to get to select each merged cell.
Once selected, you’re able to unmerge each cell as needed.
