How To Merge Or Unmerge Cells In MS-Excel

Merging cells is the process of combining more cells into one cell. Similarly, dividing a cell into multiple cells is called unmerge cells.

1. Merge & Center:

Combining more cells into one cell and centring the text is called the Merge & Centre.

Go to the Home tab
Select the range of cells and enter the text that you want to merge and center the text
Then click on the drop-down arrow of the Merge and Center
Afterwards, select Merge and Center in the Alignment group

5. Look at the 5^thstep of a picture below, in which the cells are merged and the text centred.

Click to Learn about >> Introduction to MS-Excel Spreadsheet Environment

Merging cells by combining Vertical lines and leaving horizontal lines to merge across the selected cells.

Select the range of cells that you want to merge across
Then go to the Home tab
After that, click the drop-down arrow, which appears at the right of Merge & Center In the Alignments group.
And then select Merge Across

The next step continues below the screenshot……

5. Now look at the 5th step of the screenshot below, in which the cells are merged across.

Combining more cells into one cell is called Merge Cells.

Select the range of cells that you want
On the Home tab, in the Alignments group, click the Drop-down arrow which appears at the right of Merge & Center and then select Merge Cells.

Divide a cell into multiple cells which were merged, called Unmerge Cell.

Select the range of cells that you want
On the Home tab, in the Alignments group, click the Drop-down arrow which appears at the right of Merge & Center and then select Unmerge Cells.

Merging cells is the process of combining more cells into one cell. Similarly, dividing a cell into multiple cells is called unmerge cells.