RECOMMENDED: Click here to fix Windows errors and optimize system performance
When working with data in Excel, it is common to merge cells, columns, and rows to combine numbers or text.
There are several reasons why you need to merge information in Excel. Sometimes it is to improve formatting. Or it’s a matter of combining information from several cells into one.
Whatever the reason, you can use the following methods to combine the information in Excel in any way you like
By default, each row and column of a new workbook is set to the same height and width. In Excel, you can change the column width and row height in several ways, including wrapping text and merging cells.
Combining Cells or Merging Cells in Excel – What’s the Difference?
If you merge multiple cells, you create a larger merged cell in their place.
If you combine several cells, you merge the contents of those cells or link them together to form a text string.
To merge cells in Excel
You cannot divide a single cell, but you can make it look like a cell has been divided by merging the cells above it.
- Select the cells you want to merge.
- Choose Merge and center.
Important: If you merge multiple cells, only the contents of one cell appear in the merged cell (the upper left cell for left-to-right languages or the upper right cell for right-to-left languages). The contents of the other cells you merge are deleted.
To merge cells using the Merge and Center command
- Select the range of cells you want to merge. In our example, we choose A1:F1.
- Click the Merge and center command on the Home tab. In our example, we select the cell range A1:F1.
- The selected cells are merged and the text is centered.
To access other merge options
When you click the drop-down arrow next to the Merge and center command on the Home tab, the Merge drop-down menu appears.
From here you can make your selections:
- Merge & Center: Merges the selected cells into a single cell and centers the text.
- Merge them crosswise: Merges the selected cells into larger cells, keeping each row separate.
- Merge Cells: Merges the selected cells into a single cell, but does not center the text
- Enlarge cells: enlarge selected cells
RECOMMENDED: Click here to troubleshoot Windows errors and optimize system performance
CCNA, Web Developer, PC Troubleshooter
I am a computer enthusiast and a practicing IT Professional. I have years of experience behind me in computer programming, hardware troubleshooting and repair. I specialise in Web Development and Database Design. I also have a CCNA certification for Network Design and Troubleshooting.