Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

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.

40 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Sean Thibodeaux shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

3 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Peter Bartholomew commented  ·   ·  Flag as inappropriate

    Agreed. Full screen would be good.
    With large arrays it is probable sufficient to see the 'corner' elements once you have stepped out from the array calculation itself.

  • Roy commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    Hey,

    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.

Feedback and Knowledge Base