- \n
- Keyboard Shortcut for Cell Unmerging<\/strong><\/a><\/li>\n
- Unmerge Cells Using the Ribbon’s Option<\/strong><\/a><\/li>\n
- Implementing the QAT’s Unmerge Option (One-click Unmerge)<\/strong><\/a><\/li>\n
- Find each of the worksheet’s merged cells<\/strong><\/a><\/li>\n
- Unmerge the cells and enter the original value in the empty cells<\/strong><\/a><\/li>\n<\/ol>\n
1. Keyboard Shortcut for Cell Unmerging<\/strong><\/h2>\n
Using a keyboard shortcut is the quickest approach to unmerge cells in a worksheet (at least for me).<\/p>\n
Step 1:<\/strong> To unmerge all of the merged cells from a specific range of cells, you can either choose the entire worksheet or a specific range of cells.<\/p>\n
![\"Unmerge](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/03\/Unmerge-Cells-1.png\")
<\/p>\nStep 2:<\/strong> Enter the Excel keyboard shortcut for undoing cell merging is as follows:<\/p>\n
ALT + H + M + C<\/strong><\/p>\n
In that order, press each of these keys (one after the other). The result looks like this:<\/p>\n
![\"Unmerge](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/03\/Unmerge-Cells-2.png\")
<\/p>\nThe aforementioned shortcut would immediately undo the merging of all the cells in the selected range.<\/p>\n
You should be aware of the following when unmerging cells in Excel:<\/p>\n
- \n
- If the merged cells contain any text, unmerging them will cause all of the text to move to the top-left cell of the group of merged cells that was previously unmerged.<\/li>\n
- Excel will merge all the cells if there are no merged cells in the selection. Control Z or simply pressing the keyboard shortcut again will reverse this.<\/li>\n<\/ul>\n
2. Unmerge Cells Using the Ribbon’s Option<\/strong><\/h2>\n
Using the Merge & Center option on the ribbon is a another, similarly quick method of unmerging cells in Excel.<\/p>\n
Let’s say you want to undo the merging of the cells in Column B in the dataset depicted below.<\/p>\n
![\"Unmerge](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/03\/Unmerge-Cells-3.png\")
<\/p>\nProcedure of unmerging cells in excel is in below:<\/strong><\/p>\n
Step 1:<\/strong> Choose the cells or the range of cells you want to unmerge.<\/p>\n
![\"Unmerge](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/03\/Unmerge-Cells-4.png\")
<\/p>\nStep 2:<\/strong> On the \u201cHome\u201d tab, click. Select the “Merge & Center” symbol from the \u201cAlignment\u201d group.<\/p>\n
![\"Unmerge](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/03\/Unmerge-Cells-5.png\")
<\/p>\nThat’s it! All of the merged cells in the selection would be promptly undone by the aforementioned processes.<\/p>\n
![\"Unmerge](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/03\/Unmerge-Cells-6.png\")
<\/p>\nBe aware that the top cell receives the original value from the merged cells, while the lower cells are left empty.<\/p>\n
Cells can also be merged with this toggle button (where you can simply select the cells that you want to merge and then click on this icon).<\/p>\n
3. Implementing the QAT’s Unmerge Option (One-click Unmerge)<\/strong><\/h2>\n
By including the Merge & Center symbol\u00a0to the Quick Access Toolbar, you may unmerge cells\u00a0from your worksheet more rapidly (QAT).<\/p>\n
This allows you to complete the task with a single click (as the quick access toolbar is always visible).<\/p>\n
You can add the \u201cMerge & Center\u201d symbol\u00a0to the quick access toolbar by following the instructions listed below:<\/p>\n
Step 1:<\/strong> Activate the “Home”\u00a0tab. Click the “Merge and Center” icon in the “Alignment”\u00a0group using the right mouse button. Then select “Add to Quick Access Toolbar.”<\/p>\n
![\"Unmerge](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/03\/Unmerge-Cells-7.png\")
<\/p>\nThe “Merge & Center” symbol would be added to the quick access toolbar by doing the aforementioned procedures. Simply select and choose this icon in the QAT when you need to unmerge cells in Excel.<\/p>\n
![\"Unmerge](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/03\/Unmerge-Cells-8.png\")
<\/p>\nPro tip:<\/strong> You can also reach an icon you add to the \u201cQuick Access Toolbar\u201d using a keyboard shortcut. A number would appear beneath that emblem if you held down the ALT key. Holding the Alt key while pressing that number key will allow you to use this keyboard shortcut.<\/p>\n
4. Find each of the worksheet’s merged cells<\/strong><\/h2>\n
The merged cells in the selection would all be unmerged using any of the techniques we’ve discussed so far.<\/p>\n
How would you handle it, though, if you wanted to manually unmerge some of these combined cells? (and not all).<\/p>\n
Excel’s “Find and Replace” feature can be used to rapidly locate all combined cells, pick out the ones you wish to unmerge, and then unmerge them all at once.<\/p>\n
The steps to do Excel cells unmerge are in below:<\/strong><\/p>\n
Step 1:<\/strong> Choose the range containing the cells you want to remove from the merging.<\/p>\n
![\"Unmerge](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/03\/Unmerge-Cells-9.png\")
<\/p>\nStep 2:<\/strong> Hold the Control key down and hit\u00a0the F key (or Command + F on a Mac) with the cells selected. Then\u00a0“Find and Replace” popup will then opened.<\/p>\n
![\"Unmerge](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/03\/Unmerge-Cells-10.png\")
<\/p>\nStep 3:<\/strong> Tap the \u201cFormat\u201d button in the \u201cFind and Replace\u201d dialog box. If the \u201cFormat\u201d button isn’t visible, click the \u201cOptions\u201d button, and the \u201cFormat\u201d button will appear.<\/p>\n
![\"Unmerge](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/03\/Unmerge-Cells-11.png\")
<\/p>\nStep 4:<\/strong> Select the “Alignment” tab in the \u201cFind Format\u201d dialog box. Select “Merge cells” from the menu. Select OK.<\/p>\n
![\"Unmerge](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/03\/Unmerge-Cells-12.png\")
<\/p>\nStep 5:<\/strong> In the \u201cFind and Replace\u201d popup, click the \u201cFind All\u201d button. This will locate all of the combined cells and display their cell references just beneath the dialog box. When manually selecting the cells, you want to unmerge, hold down the Control key.<\/p>\n
![\"Unmerge](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/03\/Unmerge-Cells-13.png\")
<\/p>\nStep 6:<\/strong> Unmerge all of these cells by selecting the ‘Merge and Center’ option in the ribbon (or use any of the methods covered above).<\/p>\n
![\"Unmerge](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/03\/Unmerge-Cells-14.png\")
<\/p>\nUsing this technique, you can selectively undo cell fusions while maintaining part of the original merged cells.<\/p>\n
5. Unmerge cells and enter the original value in the empty cells<\/strong><\/h2>\n
The value in the merged cell is allocated to the top-left cell when cells are unmerged in Excel, which is a problem (after the cells have been unmerged).<\/p>\n
As a result, if you have a block of three cells that is merged and contains a value, unmerge the block to reveal the value in the top cell and leave the other two cells empty.<\/p>\n
As you can see in the sample below, I have unmerged the cells (which are highlighted in blue), and all save the top cell are now empty.
![\"Unmerge](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/03\/Unmerge-Cells-15.png\")
<\/p>\nHow would you go about getting this value in each of these three cells?<\/p>\n
This is simple to accomplish with a small workaround.<\/p>\n
The processes to unmerge cells and fill each one with its original value are as follows:<\/strong><\/p>\n
Step 1:<\/strong> Choose the cells or the range of cells you want to unmerge.<\/p>\n
![\"Unmerge](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/03\/Unmerge-Cells-16.png\")
<\/p>\nStep 2:<\/strong> On the \u201cHome\u201d tab, click. Select the “Merge & Center” symbol from the \u201cAlignment\u201d group.<\/p>\n
![\"Unmerge](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/03\/Unmerge-Cells-17.png\")
<\/p>\nThe unmerged cells will be present at this time, and you will see that some cells are blank (which were earlier part of the merged cells).<\/p>\n
![\"Unmerge](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/03\/Unmerge-Cells-18.png\")
<\/p>\nStep 3:<\/strong> On the \u201cHome\u201d tab, click. Go to the \u201cEditing\u201d group and select “Find and Select.” Select “Go To Special” by clicking.<\/p>\n
![\"Unmerge](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/03\/Unmerge-Cells-19.png\")
<\/p>\nStep 4:<\/strong> Then \u201cGo To Special\u201d dialog box will appear as a result. Choose “Blanks” from the Go-To Special dialog box. Select OK.<\/p>\n
![\"Unmerge](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/03\/Unmerge-Cells-20.png\")
<\/p>\nThe aforementioned procedures would only pick those blank cells that had previously been a component of the merged cells but had since become blank.<\/p>\n
![\"Unmerge](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/03\/Unmerge-Cells-21.png\")
<\/p>\nTo duplicate the original value into these empty cells, proceed as follows:<\/strong><\/p>\n
Step 1:<\/strong> The active cell is the one that is highlighted in the list of selected blank cells.<\/p>\n
![\"Unmerge](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/03\/Unmerge-Cells-22.png\")
<\/p>\nStep 2:<\/strong> To equalize, press the equals (=) key. Consequently, the active cell will display an equal to sign. Use the up arrow to move up. This will take the reference to the cell that is immediately above the active cell.<\/p>\n
![\"Unmerge](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/03\/Unmerge-Cells-23.png\")
<\/p>\nStep 3:<\/strong> Press the Enter key while maintaining the CTRL key on your keyboard. All of these chosen blank cells will have the identical formula entered by this (in such a way that every blank cell would refer to the cell above it and pick the value from there).<\/p>\n
You will now notice that every blank cell still contains the same value as it had earlier.<\/p>\n
![\"Unmerge](\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2023\/03\/Unmerge-Cells-24.png\")
<\/p>\nThese are a few methods for unmerging cells in Excel.<\/p>\n
For ready-to-use Dashboard Templates:<\/strong><\/p>\n
- \n
- Financial Dashboards<\/a><\/li>\n
- Sales Dashboards<\/a><\/li>\n
- HR Dashboards<\/a><\/li>\n
- Data Visualization Charts<\/a><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"
Unmerge cells in Excel to revert previously combined cells back to their individual state, restoring flexibility and allowing for more granular data manipulation. Whether you\u2019re restructuring a complex spreadsheet, standardizing data formats, or preparing for detailed analysis, understanding how to unmerge cells is crucial. This guide will provide you with a clear, step-by-step approach to …<\/p>\n
- Sales Dashboards<\/a><\/li>\n
- Financial Dashboards<\/a><\/li>\n
- Unmerge Cells Using the Ribbon’s Option<\/strong><\/a><\/li>\n