Reinstate ability to temporarily evaluate part of a formula in the formula bar
In all previous versions of Excel for Mac, it was possible, while building a complex formula in the formula bar, to temporarily evaluate part of the formula by highlighting it and then using Cmd-= (Command & <equal sign>). To return the highlighted expression to what it was before evaluating, you then used Cmd-. (Command & <period>).
In Mac Excel 2016, the first part of this works fine, but the second part doesn't work at all - you are stuck with the evaluation, and there is no way to return to the expression that gave rise to it. In other words, when you do a temporary evaluation of part of the formula to check your work, you actually obliterate the very expression you're trying to test!
This alone is a total deal-breaker for Excel 2016.
Bob Greenblatt commented
I works fine if you use F9.