Ask Your Question

fabio61's profile - activity

2019-06-23 17:25:05 +0100 received badge  Notable Question (source)
2019-02-18 21:53:19 +0100 received badge  Popular Question (source)
2018-08-26 09:59:23 +0100 received badge  Notable Question (source)
2018-08-26 09:58:48 +0100 asked a question automatic fill with external references

automatic fill with external references I need to use a few spreadsheets with one sheet for every client. I want to intr

2018-08-26 09:51:42 +0100 asked a question compilazione automatica su formule

compilazione automatica su formule devo usare dei fogli elettronici fatti a schede: ogni singolo foglio corrisponde a un

2017-02-19 20:49:43 +0100 received badge  Popular Question (source)
2017-02-19 18:47:58 +0100 answered a question complex automatic fill

Great! Thanks a lot

2017-02-19 18:26:53 +0100 asked a question complex automatic fill

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?