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?