In Excel, you can scan a part of your formula with the shortcut F9
When use the shortcut F9?
Let's say you have a complex formula with a lot of VLOOKUP, INDEX, MATCH, Reference all over your workbook.
The result is not correct and you need to find the reason
To split your formula in many rows, press Alt + Enter. You will see at the end of this article a very nice tool to parse your formula automatically.
How to use the F9 key?
Select a part of your formula with the mouse
And then press F9
As you can see, the selection has been turned to display the result 🙂😎😍
But be aware of this! If at this step, you press Enter, the result will be a part of your formula and you loose the very first formula selected.
So? What to do?
In that case, instead of pressing Enter, you must leave the edit mode with the Escape key or Ctrl+Z. Like that you return to your initial formula.
Select a test
Now, if you want to visualize the result of a test, you have to select the full test (the 2 parts of the test and the comparison sign).
Parsing your formula
A great Excel developers team Roberto Mensa, Krisztina Szabó and Gábor Madács, have created a very nice tool to inspect your formulas and also to parse your formula. Like that, it's easier to visualize the different part of your formula
This is a free tool and you can download it at this address