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
Press Ctrl while dragging 
2 Likes
Thanks, It was too simple !!!
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?
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.
It works. Thanks Buddy!
Thanks, I was getting so frustrated.
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.
1 Like