How to Merge Cells In Excel (Merge & Center, Merge Across, Merge Cells)

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

MERGER OF CELLS MERGE CELLS IN EXCEL

Screenshot B

MERGER OF CELLS MERGE CELLS IN EXCEL

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.

MERGER OF CELLS MERGE CELLS IN EXCEL

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

MERGER OF CELLS MERGE CELLS IN EXCEL

End Result

MERGER OF CELLS MERGE CELLS IN EXCEL

  • 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 Merge Cells in excel-min

End Result

Merge & Center in ms excel-min

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.

Leave a Comment