Merging Cells

You can merge several cells into one cell, which is very effective for laying out spreadsheet titles. The Merge Cell function automatically centers data across the merged cells. To merge cells, follow the instructions below.
  1. Select the cells you want to merge.
  2. Click on Merge and Center button in the Formatting toolbar.

  3. The data within the cells will be merged and centered.

Note: Once the cells are merged, the cell reference is always the cell in the upper left-hand corner. In the above example, the cell reference would be A1.

To Unmerge Cells...

  1. Select all of the merged cells.
  2. Open the Format Cells dialog.
  3. Go to the Alignment tab.
  4. Remove the checkmark from the Merge Cells field in the Text Control section.

Click HERE to return to the Table of Contents.