Make the Evaluate Formula dialog box re-sizable
The evaluate formula box is unusable with large and/or CSE formulas. Please just make it re-sizeable. Thank you.
AND make it evaluate each portion of a formula: no evaluating a VLOOKUP() as a monolith, for instance.
Or at least add a checkbox to enable the more granular approach.
And to preempt the F9 comments, that helps, but has its own problems, not least of which is that for many bits in a formula, once you evaluate the piece with F9, it is unusable. So one must ESC, then begin again and not evaluate that bit or to Undo, and select a larger grain to proceed with... not always easy in practice if earlier evaluations have presented huge arrays. The Evaluate feature should be able to present that in a toaster-like usability. And the F9 approach is defeated when an array that would be presented is big.
John D. commented
this feature is more than overdue. Well it's not even a feature. It is what one would expect after decades of development.
I have stumbled upon this many many times.