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.

Note:

Text automatically wraps within a grid's cell. When print previewing PDF reports in Workspace, text cells with long text are automatically merged into the next cell to the right, if that cell is empty. When previewing HTML reports, text cells are not automatically merged. You may want to use the Merge feature, along with increasing the column width, to expand the area for text to display (the rows height automatically adjusts to display all text).

  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.