Ask Your Question

Increase increment when dragging down? [closed]

asked 2013-10-21 18:17:33 +0100

mlgoodson gravatar image

How do I get Calc to increase the increment when dragging down? If I hold control down it prevents incrementing (a cool feature), but otherwise it decrements (the increment goes down). Thanks.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-12 03:59:05.954148


Forgot to mention, that I know that I can drag down one cell, change the incremented value to one more than the original value, select both cells and drag down to create the rest of the series, but this just seems like an unnecessary hassle.

mlgoodson gravatar imagemlgoodson ( 2013-10-21 18:20:18 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2013-10-22 08:12:10 +0100

oweng gravatar image

updated 2013-10-22 08:13:26 +0100

You need to highlight the range first. Edit > Fill > Series... > select Series Type of "Growth" and set your Increment accordingly. You can assign this dialog to a hotkey if required (Tools > Customize... > Category of "Edit" and Function of "Fill Series").

edit flag offensive delete link more


Thanks. Great tip. I find the decrement when dragging down is a bit of an odd default behavior. Thanks again.

mlgoodson gravatar imagemlgoodson ( 2013-10-22 19:29:32 +0100 )edit

It should not decrement, unless you have a pair of values selected that are decreasing. There is however a difference between a linear increment (2,4,6,8) and a growth increment (2,4,8,16).

oweng gravatar imageoweng ( 2013-10-23 00:24:11 +0100 )edit

Question Tools

1 follower


Asked: 2013-10-21 18:17:33 +0100

Seen: 7,285 times

Last updated: Oct 22 '13