![excel keyboard shortcut merge cells excel keyboard shortcut merge cells](https://i0.wp.com/batasketik.com/wp-content/uploads/2020/09/Kondisi-sesudah-merge-cell.png)
Unmerge Cells and Fill the Blank Cells with the Original Value
![excel keyboard shortcut merge cells excel keyboard shortcut merge cells](https://i0.wp.com/batasketik.com/wp-content/uploads/2020/09/Langkah-langkah-merge-cells.jpg)
This method allows you to selectively unmerge cells while keeping some merged cells intact.
![excel keyboard shortcut merge cells excel keyboard shortcut merge cells](https://i0.wp.com/loop.co.id/wp-content/uploads/2021/11/Pilih-Fitur-Merge-Cells.png)
#Excel keyboard shortcut merge cells 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.
![excel keyboard shortcut merge cells excel keyboard shortcut merge cells](http://i.ytimg.com/vi/ImSlws8WVbM/maxresdefault.jpg)
You can undo this by using Control Z, or simply using the keyboard shortcut again.Īnother equally fast way to unmerge cells in Excel is to use the Merge & Center option in the ribbon.