Ask Your Question
1

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

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

this post is marked as community wiki

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.

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 2015-10-18 19:12:34.406017

Comments

JohnSUN gravatar imageJohnSUN ( 2012-10-23 09:24:58 +0200 )edit

1 Answer

Sort by » oldest newest most voted
2

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

this post is marked as community wiki

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

Press Ctrl while dragging :)

edit flag offensive delete link more

Comments

Thanks, It was too simple !!!!

Sukhwinder Singh gravatar imageSukhwinder Singh ( 2012-10-23 09:34:29 +0200 )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 gravatar imageTimM ( 2016-11-27 19:27:20 +0200 )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 gravatar imageTimM ( 2016-11-27 19:29:44 +0200 )edit

It works. Thanks Buddy!

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

Thanks, I was getting so frustrated.

Gigz gravatar imageGigz ( 2017-06-01 12:22:02 +0200 )edit

Question Tools

Stats

Asked: 2012-10-23 08:26:05 +0200

Seen: 17,172 times

Last updated: Oct 23 '12