Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
drop down list with auto suggestions | Excel Worksheet Functions | |||
select range from drop down list | Charts and Charting in Excel | |||
suggestions on creating a text value based on a date range | Setting up and Configuration of Excel | |||
formula to select numbers from a range | Excel Worksheet Functions | |||
dynamically select a range of cells for use in a formula | Excel Worksheet Functions |