Merging 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 cells:

  1. Open a report that contains a grid.

  2. Select the cells to merge.

  3. Right-click the selected cells, then select Merge.

    Tip:

    To change the formatting of the merged cell, such as changing the alignment and font selection, select Format, and then Cells.

  To separate a merged cell into individual cells:

  1. Open a report that contains a grid.

  2. Select the merged cell.

  3. Right-click the selected cell, then select Merge. The resulting cells inherit the formatting of the previously merged cell.