Ask Your Question

copy marged cells

asked 2020-06-02 14:16:05 +0200

lukasp gravatar image

updated 2020-06-02 14:22:57 +0200

LeroyG gravatar image

Hello, i have marged cells with numbers, when i want add new lines with numbers. I start with 1,2,3 and want add more lines There is not that easy and i dont know how to do it.

I copy the marged cells , but when i paste them - numbers go right so 4,5,6 but cells are not marged anymore. I have more than 100 documents with this issue and it will be very hard to manualy marge cell by cell in all documents. PLEASE any idea how to do it? In MS Excel it is working with no issue... but i dont want use that $hit anymore...

Example what i want todo in image below: what i want todo full screen : example

edit retag flag offensive close merge delete


You don't copy but instructing LibreOffice to continue a series of values (or formulas). Use CTRL+C and CTRL+V and you'll see the difference.

Opaque gravatar imageOpaque ( 2020-06-02 14:44:57 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-06-02 14:41:44 +0200

JohnSUN gravatar image

Workaround - Do it the way you do, as shown in your video. After that, select one source merged cell, and copy its format to all new cells with brush


edit flag offensive delete link more


Thanks , working well.

lukasp gravatar imagelukasp ( 2020-06-03 01:02:40 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-06-02 14:16:05 +0200

Seen: 32 times

Last updated: Jun 02