View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DoctorG DoctorG is offline
external usenet poster
 
Posts: 106
Default 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??