After unmerging the cells, you will notice that the text is now only on the B5 cell, which was previously in cell B5:E5.It can also be done by the Merge and Center command in the Alignment group in the Home tab.From the context menu, click on the ‘Merge & Center’ icon shown in the image.To resolve this issue, you need to select the merged cell B5:E5 and right-click on your mouse.Any merged cell is out of this rule, that’s why you will see the warning message if you want to do something like this. The reason behind this is that to move cells, the source and destination cell size has to be equal.Then you will notice that there will be a warning window stating that the movement of merged cells is not possible.To demonstrate this, first select the range of cells B5:E9 and try to move it by dragging the selection border around the range of cells B5:E9.But we first need to know why traditional moving cells won’t work. We need to move the range of cells B5:E9 to the empty range of cells G5:J9.This process unmerges the cells in Excel and moves them to another location in Excel while keeping the impression of being merged. Move Merged Cells by Changing Text Alignment After clicking the Keep Source Column Widths(W), you will notice, that the merged range of cells B5:E9 is now moved to the range of cells G5:J9.įor better clarity, the main dataset is copied to the original place from where a range of cells was moved.Ģ.
After that, select cell G5, and right-click on the mouse again, from the context menu, go to the Paste Special command, then click on the Keep Source Column Widths(W) from the Paste Special command.A context menu will open, from the context menu click on Copy. For this, select the range of cells B5:E9 and right-click on your mouse.In the image, the range of cells B5:E9 now moves to the empty range of cell G5:J9.Using Paste Special one can move merged cells of any size from one location to another location. Using Paste Special Command to Move Merged Cells How we move the original dataset to a new location is disclosed in this article elaborately.ġ. In this dataset, cells that are in merge conditions of different sizes are shown. 3 Easy Ways to Move Merged Cells in Excelįor demonstration purposes, we are going to use the below dataset.