Select Page

How to do ‘Merge Cells’ in Microsoft Excel.

Apr 14, 2019 | Blog | 0 comments

Merge Cells in Excel:

Merge Cells functionality is very useful at the time ,when you want to create a Header Column and under that column you want to set multiple child columns. We shall see ‘ how to merge cell in excel‘ in the following paragraphs.

How to merge cells excel:

For an example if you want to merge the ‘Product Details’ Column, shown in the Picture, then you’ve to follow the steps, provided below.

merge cell

Then select the ‘Product Detail’ row from the left side of the table and up to the end of that table.
As we want to merge all the header cells of the table we have to select all the cell of that particular table row. If you want to merge only two cells then select only two rows.

microsoft excel merge cell

Then click on the ‘Merge & Center’ button (‘Merge & Center’ button is within Home tab) Drop-Down menu will be opened. Select ‘Merge & Center’.

MS excel merge cell at center

Now, you will see that, the particular cell has been merged with other cells of that selected row.

complete  merge cell ms excel

Also Read:-

Subscribe To Our Newsletter

Join our mailing list to receive the latest news and updates from our team.

You have Successfully Subscribed!

Pin It on Pinterest

Share This