title: Insert Formula through Data Validation in excel
body: <p>In Data validation list I defined formulas: ,=1,5+($B$1/$B$2),=2+($B$1/$B$2)*2,=2,7+($B$1/$B$2)*3 ..... and works well for me because I can see all formulas in dropdown list as they are to choose the appropriate one. </p>
  
  <p>But I prefer to define them in a named range since number of formulas are around 20. Unfortunately I can see only the results instead of formula origins in dropdown list when I define as named range so makes me choose the suitable one impossible.</p>
  
  <p>I wonder whether to see the formulas itself when I defined in named range. Thanks in advance. </p>