This site uses cookies to give you the best experience of this website. Cookies are small units of data temporarily stored by your browser. The cookies in use do not contain any personal information about you and cannot be used to identify an individual user.
1 Highlight or select a range of cells. 2  Right-click on the highlighted cells and select Format Cells.... 3  Click the Alignment tab and place a checkmark in the checkbox labeled Merge cells.  To merge a group of cells and center the text, you can also use the Merge and Center button on the Excel tool bar. Again, this will only preserve the text in the upper-leftmost cell. Highlight or select a range of cells.
Merging combines two or more cells to create a new, larger cell. This is a great way to create a label that spans several columns. For example, here cells A1, B1, and C1 were merged to create the label âMonthly Salesâ to describe the information in rows 2 through 7. Select two or more adjacent cells you want to merge.