Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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!

share|improve this question
up vote 11 down vote accepted

Use TAB to accept and open the parentheses for functions.

To change to another suggestion, use the up and down arrow keys.

share|improve this answer
Hmmm... 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! – joe_coolish Apr 27 '11 at 14:56

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.