Predictive function input

[deroberg]

Seems to be a simple question, but I can't come up with the right search terms...

When typing a function into a cell, excel predicts what I am typing. How do I select one of the predictions so I do not have to type the full function name?

For example, I type "=av", and then I would like a simple keystroke to select average without finishing the word. I suppose this predictive nature could just be for confirming what I am typing is actually a function, but I would like to believe there is some additional functionality there.

It seems so trivial, but after years of my chicken pecking at the keyboard I cringe to think how much time I may have wasted

[rajeshturaha]

After typing av, excel will show all the predictions function starting with av, select that u want and hit tab key to finish the word

[deroberg]

I can't believe I haven't tried that. I keep trying to treat it like a web browser I guess.

Thanks!

[rajeshturaha]

Glade it helped you.
Plz click on the * to add to my reputation or rank this thread.

If you get a solution to your problem, as per rule, plz mark this thread as solved
Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes.