Merging Several Cells Into One Cell

You can combine two or more cells into one cell in a grid. For example, you can combine several cells to create one data cell, text cell, or formula cell.

When you merge cells, the value and format of the upper-left cell is placed into the resulting merged cell. When the merged cell is separated into individual cells, all resulting cells inherit the formatting of the previously merged cell.

  • To merge individual cells into a single cell, right-click the cells to merge, and then select Merge.

  • To separate a merged cell back into individual cells, right-click the merged cell, and then deselect Merge.