Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Understanding Range Names and Labels
I have just worked through an excelent example for creating a chart
directly from a formula on www.jkp-ads.com. This at last has got my head around Names (I think) eg. a name defined "sheet1!Top_left" =sheet1!$a$1 cannot be used or seen on another sheet a name defined "Top_left" =sheet1!$a$1 can be used on all sheets and always refers to sheet1 a name defined "Top_left" =indirect("a1") can be used on all sheets and refers to a1 on the same sheet as the name call. The bit I need help on (and sorry for the waffle) is what Labels are and how do I use them. Pointers to other reading would be welcome. The xlhelp and ms sites haven't realy helped. What I am hoping they do is make some fairly involved sheets I have easier for others to decipher . Thanks in advance for any help or suggestions Cheers RES |
#2
|
|||
|
|||
There is no one-and-only definition of "Labels", but in connection with
Names they usually mean the same thing. If you enter "Label1" in A1, and enter "=Label1" in B4, it works as "=A4", but only if you have checked ToolsOptionsCalculationAccept labels in formulas. So Labels work as a sort of implicit names. The option to disable this feature has been introduced later, because use of labels can cause many problems and is generally discouraged by experienced users. Recommended is to use explicitly defined names. Then you can get lots of support from utilities like Jan Karel Pieterse's Name Manager, to be downloaded from the site you already found. -- Kind Regards, Niek Otten Microsoft MVP - Excel wrote in message ... I have just worked through an excelent example for creating a chart directly from a formula on www.jkp-ads.com. This at last has got my head around Names (I think) eg. a name defined "sheet1!Top_left" =sheet1!$a$1 cannot be used or seen on another sheet a name defined "Top_left" =sheet1!$a$1 can be used on all sheets and always refers to sheet1 a name defined "Top_left" =indirect("a1") can be used on all sheets and refers to a1 on the same sheet as the name call. The bit I need help on (and sorry for the waffle) is what Labels are and how do I use them. Pointers to other reading would be welcome. The xlhelp and ms sites haven't realy helped. What I am hoping they do is make some fairly involved sheets I have easier for others to decipher . Thanks in advance for any help or suggestions Cheers RES |
#4
|
|||
|
|||
You might also want to visit http://www.xldynamic.com/source/xld.Names.html
-- HTH Bob Phillips wrote in message ... I have just worked through an excelent example for creating a chart directly from a formula on www.jkp-ads.com. This at last has got my head around Names (I think) eg. a name defined "sheet1!Top_left" =sheet1!$a$1 cannot be used or seen on another sheet a name defined "Top_left" =sheet1!$a$1 can be used on all sheets and always refers to sheet1 a name defined "Top_left" =indirect("a1") can be used on all sheets and refers to a1 on the same sheet as the name call. The bit I need help on (and sorry for the waffle) is what Labels are and how do I use them. Pointers to other reading would be welcome. The xlhelp and ms sites haven't realy helped. What I am hoping they do is make some fairly involved sheets I have easier for others to decipher . Thanks in advance for any help or suggestions Cheers RES |
#5
|
|||
|
|||
Thanks to you all (Bob Dave Niek)
this has added to my understanding significantly esp. local vers global names also I feel happy to leave the Labels element of Naming alone as it seems to be a bit unpredictable and can be covered using proper Names Cheers RES |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stock High-Low-Close Chart | Charts and Charting in Excel | |||
How do I put two names on a mailing list at the same address witho | Excel Discussion (Misc queries) | |||
Creating names | Excel Discussion (Misc queries) | |||
HOW DO I ENTER TWO NAMES IN ONE ROW FOR ONE ADDRESS FOR LABELS | Excel Discussion (Misc queries) | |||
Relative addressing using names or labels in formulas? | Excel Worksheet Functions |