Forum Discussion
Sebastian Schmidt
Oct 26, 2018Copper Contributor
Excel Problem with the Auto Fill Option
Hello, I have a Problem with the Auto fill Option. I want to complete a multiplication. For Example: Column A *10 Formel: =A1*10 The Problem is that only the first row is correct. The foll...
- Oct 26, 2018
May be silly, but do you have auto calc turned off? Press F9 to see if you calcs work.
Adam Ochs
Oct 26, 2018Iron Contributor
Hey Sebastian, Try manually filling in 3-4 of the cells, then do autofill. In my experience when autofill gets something wrong it is typically because i have not supplied enough data. So if you are trying to multiple them all by 10, then make c-2, 20, c-3 30, c-4 40, then try the autofill again. Adam