Shortcut to accept suggested formula in Excel
33,613
Use TAB
to accept and open the parentheses for functions.
To change to another suggestion, use the up and down arrow keys.
Related videos on Youtube
Author by
joe_coolish
Updated on September 18, 2022Comments
-
joe_coolish almost 2 years
I'm working with a lot of formulas in Excel 2007 and I would like to know what shortcut key you need to press to accept the suggested formula.
When I type in
=DEG
the first suggested formula is=DEGREEE
which is the one that I want. If I press Enter, Excel moves me to the next cell in the collumn instead of accepting the formula in the suggestion box. Also, if there is any way to change which suggestion is selected in the formula suggestion box from the keyboard, that also would be good to know.Thank you for the help!
-
joe_coolish about 13 yearsHmmm... I swear I had tried that... And I also noticed that the arrow keys work fine in the suggestion box. Thanks for the quick answer!
-
John Henckel over 4 yearstotally non-intuitive, but nice to know!