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??
|