Find All the Merged Cells in the WorkbookĪll the methods covered so far would unmerge all the merged cells in the selection.īut what if you want to go through these merged cells and manually unmerge some of those (and not all). Now, if you want to use this I can with a keyboard shortcut, simply hold the Alt key and press that number key. Hold the ALT key and you would see a number below that icon.
SHORTCUT KEYS FOR MERGING CELLS IN EXCEL PRO
Pro tip: When you add an icon to the Quick Access Toolbar, you can also access it using a keyboard shortcut. Now when you have to unmerge cells in Excel, just make the selection and click on this icon in the QAT. The above steps would add the ‘Merge & Center’ icon to the quick access toolbar.
Press each of these keys in succession (one after the other). You can choose a specific range of all cells (from which you want to unmerge cells), or you can select the entire worksheet and then unmerge all the merged cells from the entire sheet.īelow is the keyboard shortcut to unmerge cells in Excel: ALT + H + M + C The fastest way (at least for me) to unmerge cells in a worksheet is to use a keyboard shortcut.
Adding the UnMerge Option in the QAT (One-click Unmerge).Unmerge Cells using Option in the Ribbon.