Excel auto predicting where I want a number

Hoping to find an excel expert who can help me with this little issue.

Here is an example and I hope I explain it clearly.

I have three columns...A, B and C

A1 I enter a number and then go to B1 and do =A1 to input number there I will do the same for A2 to A6....all will go into column B2 to B6 Then A7 I want it go to C7 (which I will do myself like the others) but the program automatically enters the data of A7 into B7 because it thinks it is smart and that I want the data to go there but I do not.

How do I disable this feature...what is it called? It basically auto predicts where I want to enter the data after entering data in one column (B in this example) after 6 times.

Thanks.


Solution 1:

Go To: File→Options→Advanced

Under Editing Options uncheck Extend data Range Formats and Formulas

enter image description here

Click OK