Formula Evaluation (Auditing) doesn't exist for Mac?
I know, I know...Mac Users are different, but it doesn't mean they can't benefit from clear insights to their Formulas.
Alt+T, U, F in Excel for Windows gives a step-through window for evaluating a given formula. This isn't an option on Excel for Mac. Is there any work being done to enable it? Just wondering also why such basic functions for maintaining workbooks wouldn't be available across platforms.
Looking forward to hearing back.
Christopher Prost commented
I know it is not exactly the same. F9 "Evaluate" ( or [fn]+[F9] with macOS) allows the user to evaluate any section of the formula or a portion at a time. Just select the section of code (as much as you want), then press F9. I don't know about your experience, for me, I can drill down to the exact cause much quicker in a binary search speed or faster without having to wade through the entire formula. So this is far better. If you really need to wade through more than one step, gradually make bigger selections then press F9 repeatedly.
Ronald Vanden commented
Add me to the list. I'm taking a basic course on Excel, online at SkillShare, and the teacher had a whole lesson on this function – in a basic course. The lesson was completely useless to me because I didn't have this functionality on my Mac. Microsoft needs to get with it.
BPC: Request you Filter "improve Excel for Mac" for "planned" status and you will see "Add Evaluate Formula to Mac app" with approx 400 votes in favor. Please also vote for that one.
Steve of MS Excel team identified it as planned about 1.5 yrs ago as of todays date. We need more pressure to see Microsoft to --honor their commitment--. For all I know, these are not the only 2 requests logged in here for that capability. Thanks!
Charles Williams commented
My addin product FastExcel manager Pro for Mac has a great formula auditing and exploring tool (Formula Explorer Pro)
But its a chargeable product.