Menu

Merge and Unmerge Cells in MS-Excel

0 Comments

Merge and Unmerge Cells in MS-ExcelCombining more cells into one cell is called Merge cell. Similarly, dividing a cell into multiple cells which are merged, called Unmerge Cells

Merge and Unmerge Cells in Excel

1. Merge & Centre:

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

  1. Go to the Home tab

  2. Select the range of cells and enter the text that you want to merge and centre the text

  3. Then click on the drop-down arrow of the Merge and Centre

  4. Aftwards, select Merge and Centre in the Alignment group

Merge and Unmerge Cells in Excel

5. Look at the 5th step of a picture below, in which the cells merged and the text centred.

MS-Excel Merge and Unmerge Cells in Excel

2. Merge Across:

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

    1. Select the range of cells that you want to merge across
    2. Then go to the Home tab
    3. After that, click the drop-down arrow, which appears at the right of Merge & Centre In the Alignments group.
    4. And then select Merge Across
Next step continues below the Picture……
Merge Cells Across in excel

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

3. Merge Cells (Merge and Unmerge Cells in MS-Excel):

Combining more cells into one cell is called Merge Cells.

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

4. Unmerge Cells (Merge and Unmerge Cells in MS-Excel)

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

    1. Select the range of cells that you want
    2. On the Home tab, in the Alignments group, click the Drop-down arrow which appears at the right of Merge & Centre and then select Unmerge Cells.
JOIN OUR NEWSLETTER
I agree to have my personal information transfered to MailChimp ( more information )
Join over 3.000 visitors who are receiving our newsletter.
We hate spam. Your email address will not be sold or shared with anyone else.

One thought on “Merge and Unmerge Cells in MS-Excel”

Leave a Reply

Your email address will not be published. Required fields are marked *