Ask Your Question
0

Autofill cells with a formula Sequence

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

simontfs gravatar image

I have a simple formula in Cell C2;

=SUM(A1+15000)-A1

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

like this

Cell C3;
=SUM(A1+15000)-A2
Cell C4;
=SUM(A1+15000)-A3
Cell C5;
=SUM(A1+15000)-A4

Is there any way to do this?

Thank you

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

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

Lupp gravatar image

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

-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

Stats

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

Seen: 566 times

Last updated: Sep 01 '17