You have to do each sheet one by one, select the formula and do
insertnameapply and select the name

--
Regards,

Peo Sjoblom


"BBurrows" wrote in message
...
If you have already developed an excel spreadsheet with multiple
worksheets,
and formulas that refer to cells on these multiple worksheets, how do you
change the cell references to names and make sure they are applied to each
relevant worksheet and formula