One of the best ways to communicate the contents of a worksheet is to use a label. For example, you might create a list of Members with their ID numbers.
The text New Town Cricket Ground appears to span two cells, B2 and C2,
but is in fact contained within cell B2. If you select cell B2, Excel
highlights the cell’s border, which obscures the text. If you want to
combine cells B2 and C2 into a single cell, you can do so by merging the cells into a single cell.
Note:
When you merge two or more cells, Excel retains just the text in the range’s top left cell. All other text is deleted. You should strongly consider using the Merge & Center option for label text.
You can also merge the cells in multiple rows at the same time. For example, suppose your list has a main heading and a subheading. You can merge the cells in the two rows that contain headings by clicking the Home tab, clicking Merge & Center, and then clicking Merge Across.
If you want to split merged cells into their individual cells, click the Home tab, click Merge & Center, and then click Unmerge Cells.
