How to have all merged cells split in a worksheet The quickest way you can unmerge cells in a worksheet is by using the keyboard shortcut ALT + H + M + C. It can lead us to our next mission: to Unmerge the cells and have each cell filled with the original value. The other cell will be void, null, empty, blank, and a black hole, as you can see here: Black Hole Just remember that the merged cell’s value will only be in the upper-left cell. You can do the same thing with the sequential shortcut ALT>H>M>C. Once you do this, the cells will become unmerged.

Check out the home tab and click on the “Merge & Center” that you can find in Alignment Group.

Whenever there are merged cells that you want to unmerge, have the buttons merge and center used. Here are some of the simple techniques on how you can do this: Ways You Can Use Excel to Unmerge Cells How can you unmerge Excel cells if you want things to get back to normal? Whenever you have a merged cell, you may not sort the data in the columns.Ĭhoosing or filtering a range may also become an issue. Once you get related information in several cells, you may feel tempted to combine them into a single cell for comparison or alignment.ī ecause of that, merging some smaller cells into a larger one may it impossible for you to perform any simple task on your worksheet. In our tutorial, we will show you how you can easily unmerge cells in Excel.Īlthough people may not stop merging cells anytime, I hope that you’ll consider doing these simple ways in unmerging cells so you can save time and avoid becoming frustrated.

One of these features is the ability to have the cells merge.Įven if you are not using this option for yourself, you may still find yourself unmerging cells primarily in workbooks that other people share. There are so many valuable features and tools that Excel has. Because of that, you may need to unmerge cells. You may not choose individual columns whenever they have a merged cell from an adjacent column. Whenever this occurs, you may become annoyed as you do specific tasks on the excel sheets, like copying a cell that doesn’t match the show area. There are times when you get information from a web server or a colleague with a merged cell for any reason like formatting.

How to merge cells in numbers for mac