Merge or split cells

MyOffice Spreadsheet allows you to merge any number of cells in the current spreadsheet into a single cell, horizontally or vertically.

To merge cells, select them and do one of the following:

•In the Table menu, select Merge cells.

•On the Toolbar, click  Merge cells.

•Use the Alt+Ctrl+M ( Option+ Cmd+M) keyboard shortcut.

If you have created a spreadsheet using the third-party editor and uploaded it to MyOffice Spreadsheet, the  Merge cells button will not be available on the Toolbar or on the Table command menu.

MyOffice Spreadsheet allows you to split the previously merged cells.

To split a merged cell, select it and do one of the following:

•In the Table menu, select Split Cells.

•On the Toolbar, click  Split Cells.

•Use the Alt+Shift+M ( Option+ Shift+M) keyboard shortcut.

When splitting, the cell will be divided into the same number of cells that existed before the merger. The data in the merged cell will be displayed in the upper left cell of the restored range, the other cells will be empty. All cells in the range inherit the formatting of the merged cell after splitting.