Merge Cells in Excel
This page describes how to merge cells in Excel, so that two or more cells become one larger cell that spans across multiple rows and/or columns. We then discuss the limitations of merging cells in Excel.
For example, in the following spreadsheet:
- Cells B1 and C1 have been merged, to create a single cell, spanning columns B and C;
- Cells A1 and A2 have been merged, to create a single cell, spanning rows 1 and 2.
|1||Date||Number of Visitors|
How to Merge Cells in Excel
In order to merge cells in Excel:
- Select the cells to be merged;
Select the Merge & Center button .
This button is located in the 'Alignment' group, on the Home tab of the Excel ribbon:
Merge & Center Option on the Excel Ribbon
As the name suggests, if you click on the Merge & Center button, the currently selected cells will be merged, and their contents will be centered horizontally and vertically.
Recent versions of Excel also provide a drop-down menu on the Excel ribbon (see rightabove), which offers further options, such as Merge cells (without centering), Unmerge cells, etc.
How to Unmerge Cells in Excel
In order to unmerge cells in Excel:
- Select the cells that you want to unmerge (or any range of cells that contains these cells);
Select the Merge & Center shortcut button .Alternatively, you can select the Unmerge cells option from the drop-down menu on the Excel ribbon (see rightabove).
Limitations of Merging Cells in Excel
When merging cells in Excel, you should be aware of the following limitations: