Use this option to merge the cells in a column.
You can select one or more columns. (If you select only one or more cells, the merge applies to the entire columns of the cells selected).
If consecutive rows contain the same data (within any of the selected columns), those cells appear as a single 'merged' cell.
If you previously applied Merge Cells to a column, applying it again restores the columns to an un-merged state.
This option merges only cells that contain the same data. Cells with other data in the same column do not merge. If there are no consecutive cells with the same data, nothing happens. This is not an error.
- Select the column that contains cells you want to merge.
Do one of the following:
- Click .
- Right-click the selected column and select Merge Cells.