How can we help you?

Merge cells

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

The merged cell will only display the contents of the upper-left cell of the selection. If the other cells in the range contain data, MyOffice Spreadsheet will notify you accordingly.

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

In the Table menu, select Merge cells.

On the Toolbar, click editor_merge_split_icon Merge cells.

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

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

Split cells

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 editor_merge_split_icon_2 Split Cells.

Use the Alt+Shift+M (option Option+shift 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.

Was this helpful?
Yes
No
Previous
Cell ranges
Next
Reference cells and cell ranges