Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to Define a named Formula at the Worksheet level?
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to Define a named Formula at the Worksheet level?
Prefix your name with the sheetname followed by exclamation mark. E.g.
Sheet1!myName. HTH Kostis Vezerides RPJ wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to Define a named Formula at the Worksheet level?
Thanks vezerid.
Only thirty minutes to get the answer - what a valuable resource this Discusion Group is. RPJ "vezerid" wrote: Prefix your name with the sheetname followed by exclamation mark. E.g. Sheet1!myName. HTH Kostis Vezerides RPJ wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COMBINATION FORMULA | Excel Discussion (Misc queries) | |||
Copying a Formula which contains a link to another worksheet | Excel Discussion (Misc queries) | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Named SUM Formula with relative refernce(s) | Excel Worksheet Functions |