Merged cells can be a problem when you gotta sort data a certain way.
Fortunately, Excel’s Find feature is powerful enough to find and select all merged cells on a worksheet.
Once merged cells are selected, you’re able to unmerge them with a single click.
Note that it’s easy to unmerge all cells.
Unmerge All Merged Cells in Microsoft Excel
Unmerging all cells is fairly straightforward.
PressCtrl + A, tap on theHometab, then theMerge & Centericon, and then selectUnmerge cells.
If you’re on a Mac, this is the only method you’ll be able to use.
The method discussed in the next section only works in Windows.
The process involves two steps.
Don’t worry if the selection includes cells you don’t want to unmerge.
you’re able to exclude them from your selection later.
Then, hit theFind & Selectoption in theEditinggroup of tools from the ribbon at the top and selectFind.
Click theOptionsbutton in theFind and Replacewindow.
When the options appear, select theFormatbutton.
In theFind Formatwindow, select theAlignmenttab, check the box to the left ofMerge cells, and clickOK.
When you return to theFind and Replacewindow, click theFind Allbutton.
You’ll see all the merged cells listed at the bottom of the window.
Press-hold theCtrlkey and press the merged cells you want to select.
Alternatively, it’s possible for you to press-hold theShiftkey and select any merged cell from the list.
Doing so will select that and all the cells above it in the list.
The Find function isn’t the only handy feature, though.
