CODEWITHSUNDEEP
excelexcel-formulaautocomplete
Grafit
Grafit

Reputation: 699

Excel autocomplete formula

When I'm typing a long formula command in excel, like sumproduct, I can type '=s', and get a listbox with possibilities.
I want to direct with my arrow keys to the right formula and click on enter to autocomplete it to sumproduct.

I can't find out how to do this. Who knows?

Upvotes: 0

Views: 105

Answers (1)

underscore_d
underscore_d

Reputation: 6796

Pressing Tab will confirm the current selection and fill it in for you.

Upvotes: 3

Related Questions