Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Increment by 6 when I pull down cell?

When I pull a cell down the cells are usually filled with a series of numbers that increase by 1.

1, 2, 3, 4, 5 etc.

I want to pull a cell and get all the other cells filled by an increment of 6

1,7,13 etc.

How do I go about doing so?

In excel I just have to fill the first three cells with the series I want and it fills automatically. Is there any way I can do something like this in Librecalc?

Also, I would like for this to apply to formulas as well.