Merging Cells
You can merge cells on a sheet. This is particularly useful in cases where you want to place a large heading or other information in a cell. Once cells are merged, you can also center the information across the cells that have been merged (discussed in the next section).
You can merge cells that are contiguous in a particular row (from left to right), or you can merge cells that are contiguous in a column (from top to bottom).
Select the cells that you wish to merge. Select the Format menu, point at Merge Cells, and then select Define.
The cells will be merged. You will find that merged cells provide you with the elbow room to change font sizes or align information (such as headings) and set them off from the rest of the spreadsheet.
Note
In cases where the data in merged cells will be hidden by the merge, you are given the option of adding the data to the first cell (the beginning of the merged cell area) in the merged range.
One thing that you should be aware of concerning merged cells is that you cannot insert (add) columns or rows into the area where cells have been merged. The merged cells become a barrier to the insertion of columns or rows. The only way you can insert a column or row into a merged range is to remove the merged area, insert the row or column, and then remerge the cells.
To “unmerge” a cell range, select the cell range, select the Format menu, point at Merge Cells, then select Remove on the cascading menu. The merged cell range will be returned to individual cells.