Ask Your Question

I can merge cells in one single row (from 2 columns), but how can I do it automatically for other rows in the same worksheet?

asked 2020-01-11 02:51:07 +0100

pegasus gravatar image

updated 2020-01-11 04:22:32 +0100

I want to merge cells in all rows of a worksheet in one shot.

edit retag flag offensive close merge delete


I wonder what might be a use case to desire this (merging 2 adjacent cells in all rows end up in a single usable column).

Opaque gravatar imageOpaque ( 2020-01-11 13:06:05 +0100 )edit

That actually could be useful if applied not to the whole sheet, but to selection. In AutoCAD, the table cell merge tool had 3 modes: merge all selected; merge by rows; merge by columns.

Mike Kaganski gravatar imageMike Kaganski ( 2020-01-11 13:53:10 +0100 )edit

@Mike Kaganski - I wonder about, as OP wrote, in all rows of a worksheet (which for me means all 1048576 rows and is a different thing than all rows of a selected range by rows) not about merging in general (may be due to a lack of imagination)

Opaque gravatar imageOpaque ( 2020-01-11 14:16:04 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-01-17 22:53:59 +0100

Opaque gravatar image

updated 2020-01-18 00:38:26 +0100


there is a long running enhancement request - not yet assigned #tdf59345. So there is no such automatic functionality merge by rows and/or merge by colum in LibreOffice.

Workaround (Description is about merging cells in colums A and B row by row for all rows):

  • Select range A1:B1 and merge
  • Copy the merged cell
  • Type A:A into the Name Box left of the input line (turns into what you see in the screenshot and selects all cells in column A) --or-- just click column header letter A
  • CTRL+V

image description


  • Merging by columns works analog.
  • This is only an example you could specify any arbitary target for the merged cells to be added (e.g putting F100:F150 into Name Box will effectively merge F100:G150 row by row after CTRL+V)

Hope that helps.

If the answer helped to solve your problem, please click the check mark (✔) next to the answer.

edit flag offensive delete link more


EXODO 1:1 Estos son los nombres de los hijos de Israel que entraron en Egipto con Jacob; cada uno entró con su familia:
Exodo 1:2 Rubén, Simeón, Leví, Judá, Exodo 1:3 Isacar, Zabulón, Benjamín, Exodo 1:4 Dan, Neftalí, Gad y Aser. Exodo 1:5 Todas las personas que le nacieron a Jacob fueron setenta. Y José estaba en Egipto. Exodo 1:6 Y murió José, y todos sus hermanos, y toda aquella generación. Exodo 1:7 Y los hijos de Israel fructificaron y se multiplicaron, y fueron aumentados y fortalecidos en extremo, y se llenó de ellos la tierra. Exodo 1:8 Entretanto, se levantó sobre Egipto un nuevo rey que no conocía a José; y dijo a su pueblo: Exodo 1:9 He aquí, el pueblo de los hijos de Israel es mayor y más fuerte que nosotros. Exodo 1:10 Ahora, pues, seamos sabios ...(more)

pegasus gravatar imagepegasus ( 2020-01-19 01:58:49 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-01-11 02:51:07 +0100

Seen: 55 times

Last updated: Jan 18