How to Fill same data in a column by dragging?

English
, , , ,
#1

Hi,
How can we fill the same date in a column by dragging? In MS excel we can fill 2-3 cells with a data and then drag it down to fill the same data in all cells, but in liberoffice calc, even after filling 3-4 cells with same data, when we select this range and drag it down, it is incrementing the the data.

2 Likes
#2

Maybe this answer?

#3

Press Ctrl while dragging :slight_smile:

2 Likes
#4

Thanks, It was too simple !!!

#5

I realize this is an old thread but I still can’t seem to get it to work by this method. Is there some setting I need to alter to have this work?

#6

I should also mention that I am trying to use a basic formula that I want to repeat down about 100 cells: “=B7” and it is not working even if I fill 3-4 cells with the same.

#7

It works. Thanks Buddy!

#8

Thanks, I was getting so frustrated.

#9

Hi TimM,
I also can’t get CTRL key to work. I’m thinking this feature might only work in the old versions.

But you can reference the cells using $, and that will stop it from incrementing on drag.

Example:

=CONCATENATE($B$1;$B$2)

If you drag above value, it will not increment the referenced cell ID.

Example 2:

=CONCATENATE(A1;$B$2)

With above example, only the first reference cell gets incremented, and the second reference stays the dame on a cell drag.

#10

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.