Forum Discussion

César Chaires's avatar
César Chaires
Copper Contributor
Apr 12, 2018

Selecting a formula from the menu with keyboard

Hello to everybody.

 

I'm looking for your help. I want to know how can I select a formula from de displayed menu while introducing it with the keyboard. For example, when I write "=S", then Excel prompts a menu with some possible functions such as SUM, SUMIF, SQRT, etc. How can I select one of those with my keyboard without writing them all?

 

Thanks

  • Hi,

     

    When you type = and start to write the function name, Excel shows you the available functions that start with this character that you've typed, and when you typing more characters the IntelliSense menu start to shrink.

     

    When typing enough number the function characters, you will see the function is highlighted in the top of the IntelliSense menu.

    In this point, you can pick it up by pressing TAB.

     

    Another tip, just types the first character of the function name, if the function isn't in the top the IntelliSense menu, you can use the down arrow to access it, and then press TAB.

     

    Hope that helps

    Haytham

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor

    Hi,

     

    When you type = and start to write the function name, Excel shows you the available functions that start with this character that you've typed, and when you typing more characters the IntelliSense menu start to shrink.

     

    When typing enough number the function characters, you will see the function is highlighted in the top of the IntelliSense menu.

    In this point, you can pick it up by pressing TAB.

     

    Another tip, just types the first character of the function name, if the function isn't in the top the IntelliSense menu, you can use the down arrow to access it, and then press TAB.

     

    Hope that helps

    Haytham

Resources