Introduction
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.
Purpose
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.
Learning Objects
- 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
Screenshot A
Screenshot B
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.
Conclusion
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
End Result
- 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.
End Result
Conclusion
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.
Join Our WhatsApp Group
Nazim Khan (Author) 📞 +91 9536250020
[MBA in Finance]
Nazim Khan is an expert in Microsoft Excel. He teaches people how to use it better. He has been doing this for more than ten years. He is running this website (TechGuruPlus.com) and a YouTube channel called "Business Excel" since 2016. He shares useful tips from his own experiences to help others improve their Excel skills and careers.
