Merging cells is to combine two or more adjacent cells into one. Cells may be merged both horizontally and vertically.
To merge or split cells, select several cells and do the following:
•Click > or .
•Use the button to merge cells or the button to split cells (the commands displayed in the context menu depend on the selected cells).
•Use the context menu commands (the commands displayed in the context menu depend on the selected cells).
•Press () to merge and () to split cells.
The merged cell keeps formatting of the data displayed in the first cell of the selected range (including background color, font type or other formatting).
When splitting cells, the merged cell will be divided into the same number of cells as it contained before the merger. The data from the merged cell will be displayed in the upper left cell of the restored range, the other cells will be empty.