Select a formula / range from Excel drop down suggestions
 

As we enter a formula in a cell, Excel finds matches of what is being written
comparing it to (all) formulas and ranges of the current workbook and
displays them in a drop down box just beneath the cell.
Can someone please tell me if there is a key combination that inserts the
currently selected list item in the formula being written and save me the
trouble of writing the whole thing by hand??

Select a formula / range from Excel drop down suggestions
 

If you click the "fx" function button instead, then you can follow prompting
that guides you through completing the formula.

If you're typing a formula normally (not using the "fx" function button),
then when the available functions start to show, use your down arrow to get
to the right one and then the tab key to select it.
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"DoctorG" wrote:

As we enter a formula in a cell, Excel finds matches of what is being written
comparing it to (all) formulas and ranges of the current workbook and
displays them in a drop down box just beneath the cell.
Can someone please tell me if there is a key combination that inserts the
currently selected list item in the formula being written and save me the
trouble of writing the whole thing by hand??

Select a formula / range from Excel drop down suggestions
 

Thanks KC... I have been using Excel for ages, programming and all, but I
couldn't find this anywhere. Is there somewhere I can find all of these
"shortcuts"?

"KC" wrote:

If you click the "fx" function button instead, then you can follow prompting
that guides you through completing the formula.

If you're typing a formula normally (not using the "fx" function button),
then when the available functions start to show, use your down arrow to get
to the right one and then the tab key to select it.
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"DoctorG" wrote:

As we enter a formula in a cell, Excel finds matches of what is being written
comparing it to (all) formulas and ranges of the current workbook and
displays them in a drop down box just beneath the cell.
Can someone please tell me if there is a key combination that inserts the
currently selected list item in the formula being written and save me the
trouble of writing the whole thing by hand??

Select a formula / range from Excel drop down suggestions
 

Just double-click on the function you want from the list.

Key combination I don't about.

Would be nice to find out.


Gord Dibben MS Excel MVP

On Fri, 12 Feb 2010 10:29:01 -0800, DoctorG
wrote:

As we enter a formula in a cell, Excel finds matches of what is being written
comparing it to (all) formulas and ranges of the current workbook and
displays them in a drop down box just beneath the cell.
Can someone please tell me if there is a key combination that inserts the
currently selected list item in the formula being written and save me the
trouble of writing the whole thing by hand??

Select a formula / range from Excel drop down suggestions
 

When I was trying to learn "pro" efficiency tips, I initially relied on John
Walkenbach, who has a great site (www.j-walk.com/ss) and several great books
("Favorite Excel Tips & Tricks" is one I reference frequently). There are
many other great books and sites as well (such as www.ozgrid.com, click on
"Free Excel Training" on the left side). Have FUN!
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"DoctorG" wrote:

Thanks KC... I have been using Excel for ages, programming and all, but I
couldn't find this anywhere. Is there somewhere I can find all of these
"shortcuts"?

"KC" wrote:

If you click the "fx" function button instead, then you can follow prompting
that guides you through completing the formula.

If you're typing a formula normally (not using the "fx" function button),
then when the available functions start to show, use your down arrow to get
to the right one and then the tab key to select it.
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"DoctorG" wrote:

As we enter a formula in a cell, Excel finds matches of what is being written
comparing it to (all) formulas and ranges of the current workbook and
displays them in a drop down box just beneath the cell.
Can someone please tell me if there is a key combination that inserts the
currently selected list item in the formula being written and save me the
trouble of writing the whole thing by hand??

Select a formula / range from Excel drop down suggestions
 

Thank you both for your input. I am still wondering why I didn't think of the
double-click myself.

Maybe it's because I am using the keyboard at the time and I was trying to
find a keyboard way to do it. Just for that I opt for KC's solution. [Tab]
does just fine for me!!

Thanks again.

Select a formula / range from Excel drop down suggestions
 

I just learned about the Tab key myself, thanks to KC


Gord

On Fri, 12 Feb 2010 12:01:01 -0800, DoctorG
wrote:

Thank you both for your input. I am still wondering why I didn't think of the
double-click myself.

Maybe it's because I am using the keyboard at the time and I was trying to
find a keyboard way to do it. Just for that I opt for KC's solution. [Tab]
does just fine for me!!

Thanks again.