Results 1 to 9 of 9
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Name Labels (Excel 2000 >)

    Megl asked recently about Apply in Names. Can I ask about INSERT | NAMES | LABELS. Excel help is not clear on this dialog and what to do with it. AFAIK, excel works with labels when you choose to activate a check box in TOOLS | OPTIONS in the CALC tab. Then you can say : QTR1 AREA1 * QTR2 AREA4 etc. But what do you do with the labels dialog, as well as what are diffs with the column and row labels options?

    TIA
    Regards,
    Rudi

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Name Labels (Excel 2000 >)

    It is a way to avoid clashes when duplicate lables are involved.

    Say you have two tables, both containing the same headings.

    When you enable using lables, Excel will use the lables from the first table of your sheet.

    If you want to use the lables from the second table, adding that table as a label range forces Excel to use those headings for labels.

    IMO this is a method to avoid, better to use defined names, as they are never ambiguous.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Name Labels (Excel 2000 >)

    Ah, this is a little clearer. However, how will I add the ranges? Do I select the whole table or do I select each label and add it induvidually? Also, what is column label and row label options?
    I understand that you say to avoid this feature...and I do... My question is simply for knowledge sake.
    Tx
    Regards,
    Rudi

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Name Labels (Excel 2000 >)

    To create row labels, select a single column of labels.
    To create column labels, select a single row of labels.

  5. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Name Labels (Excel 2000 >)

    Tx...as simple as that eh!

    One last Q:
    According to Jan Karels reply above, if I have 2 tables, Excel uses the first tables labels default. If I use this method to add the labels of the second table, how will I distinguish the two. Take you diagram Hans. If I want to add say: =North Jan (from the first table) + North Jan (from the second table) together for a total, how is Excel knowing to add the values from both tables together? When I set up the labels in the dialog, I cannot specify names for them?

    I hope this is clear.
    Regards,
    Rudi

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Name Labels (Excel 2000 >)

    I think you'd have to define unique names manually, say Table1_Jan and Table2_Jan etc. It seems more trouble than it's worth to me.

  7. #7
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Name Labels (Excel 2000 >)

    I agree.
    Tx
    Regards,
    Rudi

  8. #8
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Name Labels (Excel 2000 >)

    In Excel version 12, things like this become easier. You can designate ranges as being tables, which enables you to write formulas like:

    =SUM(Table1[Sales],Table2[Sales])

    Or:

    =SUM(Table1[#Data])
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  9. #9
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Name Labels (Excel 2000 >)

    Ah, yes...this makes sense! Tx for this info. I look forward to Excel 12
    Regards,
    Rudi

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •