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:

•On the Table menu, select Merge cells.

•On the Toolbar, click the Merge cells.

•Use the context menu.

•Use the Alt+Ctrl+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:

•On the Table menu, select Split cells.

•On the Toolbar, click Split Cells.

•Use the respective command from the context menu.

•Use the Alt+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.