Separate cells can be merged into one cell in Excel. Useful for titles that need to span multiple columns.
One big cell
Anyone who creates tables or overviews in Excel will sooner or later have to deal with titles or headings that have to run over different columns. Then it is useful to merge different cells. The cells then turn into one large cell that is displayed across multiple columns. The contents of the cells are displayed in the center of the merged cell.
To combine
Merging works from Excel 2010 in the following way:
- Select the cells you want to merge. Do this by clicking on the first cell, in our example that is cell E3. Hold down the left mouse button while dragging the mouse to the cell to be merged, for example cell F3. Then release the mouse button.
- Make sure the ‘Home’ tab is selected in the Ribbon by clicking on it.
- In the ‘Alignment’ group, click Merge and Center. You may only see the icon. Then click on that.
The selected cells are merged into one cell. The columns below will continue to exist. To unmerge, select the merged cells and click again Merge and Center.