Keyboard shortcut fans might know that you can start typing a formula, like =VLOOKUP(, into a cell and then press Ctrl+A to open the Functions Argument for that function.įrequently when using Excel, though, you might need to create formulas that nest one function inside of another function-for example, like when you have to put a MATCH function inside of an INDEX or VLOOKUP function.

Normally, you would open the Functions Argument dialog by clicking the fx icon (known as Insert Function) located on the Formulas tab of the ribbon and also to the left of the Formula Bar.