Ask Your Question

How to fill in merged cells without split them ? [closed]

asked 2014-04-09 17:47:12 +0100

madbear gravatar image

updated 2015-09-09 01:21:18 +0100

Alex Kemp gravatar image

Hi !

Here is what I try to do : I merged two cells ( A1 and B1 ) and enter '1' in that merged cell. I want to use incremental fill function to have my horizontal serie starting from 1 to 10 with my cells merged ( C1 with D1 contain 2, E1 with F1 contain 3, ... and so on )

Here is what I have tryied to do :

I manually merge all the cells I need to be merged. And then I use the fill handle to make my serie over my merged cells. Result : Fail. The merged cells get split and I get a serie from 1 to 20 in splitted cells instead of a serie of 1 to 10 in my 10 manually merged cells.

I have also tried the " Edit - Fill - Serie " method but the result is worst with strangely merged cells...

Is there a way to do what I want ? I thought the fill function could do that but it appears it can't or I'm wrong ?

Here is my software infos : OS : Ubuntu 13.10

LibreOffice : Version: Build ID: 410m0(Build:2)


PS : Sorry about my bad english... I do my best.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-20 19:09:39.076173

1 Answer

Sort by » oldest newest most voted

answered 2014-04-09 19:11:42 +0100

w_whalley gravatar image

updated 2014-04-09 19:16:22 +0100

I merged cells A1 and B1, then merged cells C1 and D1. Then I entered 1 in merged (A1 B1) and =A1+1 in merged (C1 D1). Then I copied the merged cell (C1 D1) and pasted it into the range E1 to T1. I found that the formula and the merged cell format were both replicated.

edit flag offensive delete link more


Thank you ! That works as expected. Simple and effective !

madbear gravatar imagemadbear ( 2014-04-09 22:54:05 +0100 )edit

Brilliant that worked great thanks

rste2000 gravatar imagerste2000 ( 2020-02-22 10:00:42 +0100 )edit

Question Tools

1 follower


Asked: 2014-04-09 17:47:12 +0100

Seen: 1,061 times

Last updated: Apr 09 '14