Improve Dynamic Merged Cells


Version: 2026

Type: Features

Category: Data Handling

Subcategory: Worksheet

Jira: ORG-32064


Origin supported dynamic merge of adjacent cells if the value/text are the same. But it’s kind of hidden.

User would need to go to Worksheet Properties or Format Cells dialog to turn it on. Also when clicking on a merged cell and edit would change the clicked cell only so not easy to edit all cells.

The following improvements are made:

  • Mini toolbar to turn on dynamic merge on/off on column label row header or multi-selection.

    image-20250922-180902.png
  • Single click or double click on dynamically merged cells and type will edit value/text for all cells. E.g. if change it to cos(A), it will dynamically merge all 3 F(x) cells.

    image-20250922-180940.png
  • 2nd Single click will edit a single cell, e.g. only F(x) cell of column C is selected. Type will edit it only

    image-20250922-181015.png
  • Also supported in data area. E.g. select A1 to B4 and turn dynamic merge on. Since A2, A3, B2, B3 are all 5, they will be merged dynamically.

    image-20250922-181230.png