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.
|1||Date||Number of Visitors|
For example, imagine you want a heading in your Excel spreadsheet, to be centred across two columns of data (see cells B1-C1 in the above example spreadsheet on the right).
The best way to do this is to merge cells B1 and C1, to create one single merged cell, spanning columns B and C.
We have also merged cells A1 and A2 in the example spreadsheet above.
In order to merge cells in Excel, you simply need to select the cells to be merged and select the Merge & Center button .
This button is located on the Home tab of recent versions of Excel (2007 and later), and on the formatting toolbar of Excel 2003.
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 at the side of the Merge & Center button (see rightabove), which offers further options, such as Merge cells (without centering), Unmerge cells, etc.
In order to unmerge cells in Excel, simply select any range of cells that contains the merged cell and select the Merge & Center shortcut button .
Alternatively, you can select the Unmerge cells option from the drop-down menu shown above.
When merging cells in Excel, you should be aware of the following limitations: