Ask Your Question

Autofill cells with a formula Sequence

asked 2017-09-01 22:19:19 +0200

simontfs gravatar image

I have a simple formula in Cell C2;


I would like calc to auto fill the formula+1 for the selected cells (C2:C270)

like this

Cell C3;
Cell C4;
Cell C5;

Is there any way to do this?

Thank you

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-09-01 22:38:14 +0200

Lupp gravatar image

updated 2017-09-01 22:38:34 +0200

-1- Learn about absolute vs relative addressing.
=SUM(A$1+15000)-A2 'Sheet' > 'Fill Cells' > 'Down' (Ctrl+D) or drag fill handle with the mouse.

-2- For what reason that contrived formula? Use =A$1-15000-A2 or similar.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-09-01 22:19:19 +0200

Seen: 1,308 times

Last updated: Sep 01 '17