Merging combines two or more cells to create a new, larger cell is called Merge Cell. This is very useful feature in excel to create a label that spans several columns.
Combination of two or more cells in a spreadsheet to join one or more adjacent cells (horizontally or vertically or both) into one larger cell.
This is perfect for text that runs over multiple cells. Without changing the Excel width or height of the individual cells in a column or row, user can merge all the cells together. The text will also automatically expand.
- Merge & Center
- Merge Across
- Merge Cells
- Unmerge Cells
A. Process to Merge & Center in Excel
- To combine and center the content of the selected cells in a new larger cell. Refer the below step by step process.
- For example, we want to merge cell from B4 to F4 and bring the content in center.
- Select entire raw from B4 to F4 and click >Merge & Center> Merge & Center
Once you will click on Merge & Center, you will get below result.
You will find the cells have been merge and the content has placed in Center.
This feature is very useful and mostly used when text that runs over multiple cells. Without changing the Excel width or height of the individual cells in a column or row, user can merge all the cells together.
B. Process to Merge Across in Excel
- Merge across is combining or joining of two or more cells into one cell. It is used mostly in headers.
- Click Home>Merge & Center>Merge Across>OK
- Merge Across combines or joins the columns but the rows are separated. As above Screenshot.
C. Process to Merge Cells
- Merging cell is also combining or joining of two or more cells into one cell but it does not change the text alignment
- Click Home>Merge & Center>Merge Cells
- Refer the screenshot below.
Merge & Center will take the value and formatting from the top left cells and also centered the text, however merge cells take the value and formatting from these top left cells but do not centered the text.