How to Fill same data in a column by dragging? [closed]

asked 2012-10-23 08:26:05 +0100

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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.

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-18 19:12:34.406017

answered 2012-10-23 09:29:47 +0100

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Press Ctrl while dragging :)

edit flag offensive delete link

Comments

Thanks, It was too simple !!!!

Sukhwinder Singh ( 2012-10-23 09:34:29 +0100 )edit

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?

TimM ( 2016-11-27 19:27:20 +0100 )edit

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.

TimM ( 2016-11-27 19:29:44 +0100 )edit

It works. Thanks Buddy!

rashmimhatre100@gmail.com ( 2017-05-03 13:17:27 +0100 )edit

Thanks, I was getting so frustrated.

Gigz ( 2017-06-01 12:22:02 +0100 )edit

add a comment

How to Fill same data in a column by dragging? [closed]

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-18 19:12:34.406017

Comments

1 Answer

Comments

Question Tools

Stats

Related questions

How to Fill same data in a column by dragging? [closed] edit

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2015-10-18 19:12:34.406017

Comments

1 Answer

Comments

Question Tools

Stats

Related questions

How to Fill same data in a column by dragging? [closed]

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-18 19:12:34.406017