Merge cells

You can merge two or more adjacent cells into one cell. To do that,

1. select two cells or a range of cells with the mouse,

   Note: the selected cells MUST be adjacent.

2. click the Merge icon situated at the Home tab of the top toolbar and select one of the available options:

   Note: only the data in the upper-left cell of the selected range will remain in the merged cell. Data in other cells of the selected range will be deleted.

   • if you select the Merge & Center option the cells of the selected range will be merged and the data in the merged cell will be centered;
   • if you select the Merge Across option the cells of each row of the selected range will be merged and the data in the merged cells will be aligned by the left side (for text) or by the right side (for numeric values);
   • if you select the Merge Cells option the cells of the selected range will be merged and the data will be aligned by the left side (for text) or by the right side (for numeric values).

To split the previously merged cell use the Unmerge Cells option from the Merge drop-down list. The data of the merged cell will be displayed in the upper-left cell.

Return to previous page