by Sebastian42 » Wed Feb 08, 2017 6:43 am
I set up a SS, but find that in a column with empty cells, Excel automatically inserts the (product) formula - and its result - when I type the values of the arguments into other cells - and then click on the cell where I WANT the result. It's like a mysterious magic which I would like to understand. I did put the multiplication formula in the top of the column, but I have never seen THIS kind of auto-filling before, so did not expect that pleasant surprise. Can anyone enlighten me as to how that comes about?