clicking on cell while using formula adds it to formula
In older versions, (2011) when you entered "=" and clicked on a particular cell, it added that cell's value to the formula. You could then click on another cell and it would use addition to add the second selection. Example: When entering = and clicking A1 then clicking B1, then clicking C1, formula would calculate "=A1+B1+C1". Now we have to manually enter "+", or the cell first clicked is replaced with the most recently selected cell.
Finally, this was added back in on May 4, 2020, with Version 16.37 (Build 20050303)
I have used Excel since the first day 1.0 was released in 1985 in a box of 3.5" disks. "Click to add" was always just a natural intuitive part of the application, until someone decided to remove it.
Unfortunately, it still isn't enabled by default though.
Why is it that MS when attempting to improve something always removes something good....?