How to Define a named Formula at the Worksheet level?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I know how to "Insert, Name, Define" a formula at the Workgroup level - but
how can I do this at the Worksheet level only?

The infuriating thing is that I have done this before but I cannot remember
how (or where I found out how to)!

Thanks in advance.

RPJ
 
Prefix your name with the sheetname followed by exclamation mark. E.g.
Sheet1!myName.

HTH
Kostis Vezerides
 
Thanks vezerid.

Only thirty minutes to get the answer - what a valuable resource this
Discusion Group is.

RPJ
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top