Inspect a formula with F9

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 🙂😎😍

Avoid mistake

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.

Tutorial video

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).

And after F9, the result in your formula is

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

Related posts

Permanent link to this article:

Leave a Reply

Your email address will not be published.