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.
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.
Then click on the ‘Merge & Center’ button (‘Merge & Center’ button is within Home tab) Drop-Down menu will be opened. Select ‘Merge & Center’.
Now, you will see that, the particular cell has been merged with other cells of that selected row.