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.

29 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

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

    2 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • 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