Often, when I am entering formulas in Excel 2010, as soon as I enter a cell reference, and then a + or * to add or multiply things together, Excel will make some kind of correction that creates a range, which I then have to delete to continue entering my formula.
For example: I'm trying to enter the formula:
$U$2 * (C2 + J2 * $W$2 / 2)
This weird feature didn't trigger on the first *, but as soon as I entered the plus after C2, Excel changed the + to +2:2, and the whole 2nd row was suddenly selected as a range.
$U$2 * (C2 +2:2
What causes this range feature to happen, and how can I prevent it?