View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
AccessHelp AccessHelp is offline
external usenet poster
 
Posts: 213
Default Named Range Question.

Try this,

Go to: Tools|Options, then check the box "Formulas" under tab "View"

That will show cells with defined name formulas.

I hope that is what you want.

"LuftRider" wrote:

I have an amortization template that I downloaded some time ago. It has
numerous named cells and named ranges. Is there any way other than
individually converting the named cell(s) to their respective absolute
references? Thanks,
Glen


--