Excel 2024: See Intermediate Calculations
January 13, 2025 - by Bill Jelen
My friend Mike Girvin at the ExcelisFun YouTube channel has a great trick when explaining a long formula. Mike will select part of the formula in the formula bar and press F9 to calculate just that part of the formula. It is a cool trick, but you must remember to press Escape or you will hard-code the intermediate results in the formula.
In 2023, the Excel team provided a better alternative. If you select part of the formula in the formula and pause for a few seconds, a tooltip appears with the intermediate results. Here is an example showing the array stored in the Passcodes named range: