Named range labels in formulas

  • Thread starter Thread starter KLUG
  • Start date Start date
K

KLUG

I created names ranges in an existing workbook. In order to get formulas to
use the named range in the formula, I hit F2 in a formula cell and ENTER as
directed by the help files. I also tried re-typing the formulas but still am
unable to see the names as labels in the formula. Any suggestions?
 
Maybe this...

Select the cell with the formula
Goto the menu Insert>Name>Apply
Select the named range that applies to that particular formula
OK
 
Back
Top