How can we help you?
Merge or unmerge cells
  • Expand the workspace
  • Select cell ranges
  • Resize cells
  • Merge or unmerge cells
  • Insert columns or rows
  • Select colums or rows
  • Hide or unhide a column or row
  • Resize a column or row
  • Freeze columns, rows, or area
  • Group columns or rows
  • Delete columns or rows
Product:
Application: Table Home Edition

Merge cells

MyOffice Spreadsheet allows you to merge any number of cells in the current spreadsheet into a single cell. When you merge multiple cells, the resulting cell will be formatted like the upper-left cell of the merged range.

The merged cell will only display the contents of the upper-left cell of the selection.

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

In the Table menu, select Merge Cells.

On the Toolbar, select the Cells section and click t_design_merge_cells Merge Cells.

Right-click the selected range of cells and select Merge Cells from the context menu.

Press Ctrl+Alt+M.

Unmerge 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 Unmerge Cells.

On the Toolbar, select the Cells section and click editor_merge_split_icon Unmerge Cells.

Right-click the selected cell and select Unmerge Cells from the context menu.

Press Alt+Shift+M.

The data contained in the merged cell will be placed in the upper-left cell of the resulting range.

The resulting cells will be formatted like the merged cell.

Was this helpful?
Yes
No
Previous
Resize cells
Next
Insert columns or rows