We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

complex automatic fill [closed]

asked 2017-02-19 18:26:53 +0200

fabio61 gravatar image

I have a problem with the automatic fill function when I use complex formulas: I would like to have some of the parameters automatically filled but leave alone some fixed parameters.

For example: In the column A I have the series 1,2,3,4 in the cells A1,A2,A3,A4 In the cell B1 I have the value of 10 I would like to sum the values of the series in the column A with the cell B1

However, if I use the formula =A1+B1 say in cell C1 and I attempt an automatic fill I have the series A1+B1, A2+B2, A3+B3, A4+B4 and not my desired result (that would be, of course, A1+B1, A2+B1, A3+B1, A4+B1).

Is there a way to have the formulas filled automatically but leaving alone some of the parameters?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-25 01:16:28.579011

2 Answers

Sort by » oldest newest most voted

answered 2017-02-19 18:30:26 +0200

Lupp gravatar image
=A1+B$1  It's absolute vs. relative addressing.
edit flag offensive delete link more

answered 2017-02-19 18:47:58 +0200

fabio61 gravatar image

Great! Thanks a lot

edit flag offensive delete link more


If the answer solves your question please tick the ✔.

m.a.riosv gravatar imagem.a.riosv ( 2017-02-19 19:04:49 +0200 )edit

Question Tools

1 follower


Asked: 2017-02-19 18:26:53 +0200

Seen: 72 times

Last updated: Feb 19 '17