Named range labels in formulas
 

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?

Named range labels in formulas
 

Maybe this...

Select the cell with the formula
Goto the menu InsertNameApply
Select the named range that applies to that particular formula
OK

--
Biff
Microsoft Excel MVP


"KLUG" wrote in message
...
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?