Ask Your Question
0

How to Fill same data in a column by dragging?

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

this post is marked as community wiki

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

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

Sukhwinder Singh gravatar image Sukhwinder Singh
3 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.

delete close flag offensive retag edit

Comments

Maybe this answer?

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

1 Answer

Sort by » oldest newest most voted
0

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

this post is marked as community wiki

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

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

burbuja gravatar image burbuja
16

Press Ctrl while dragging :)

link delete flag offensive edit

Comments

Thanks, It was too simple !!!!

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

Login/Signup to Answer

Donate

LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!

Question tools

Follow

subscribe to rss feed

Stats

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

Seen: 110 times

Last updated: Oct 23 '12