Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does InsertNameLabel & InsertNamePaste do?
I typed in a label in B1 called My Sales. I used InsertNameCreate to create
a named range for B2 to B10 with the My Sales label I typed as the named range. I understand that if I click InsertNameApply it will replace the B2 to B10 range I have already used in a formula with the name, My Sales. So what does InsertNamePaste do? Also, what does InsertNameLabel do? I thought I created labels just by typing them into the spreadsheet at the top of the column of data I want to label. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does InsertNameLabel & InsertNamePaste do?
<insert<name<paste displays a list of Named Ranges
that you you can pick from to use in a formula. Since I use Named Ranges quite a bit, I just use the [F3] shortcut, instead. Example: If I have A2:A100 named: Sales I can sum those values by.... Type: =SUM( Press: [F3]....Select "Sales" from the list Type: ) Press: [ENTER] The resulting formula is: =SUM(Sales) I've never had much use for Label Ranges... but here's an explanation and example: http://www.bettersolutions.com/excel...E824631331.htm Does that help? Post back if you have more questions. Regards, Ron Microsoft MVP - Excel "Studebaker" wrote in message ... I typed in a label in B1 called My Sales. I used InsertNameCreate to create a named range for B2 to B10 with the My Sales label I typed as the named range. I understand that if I click InsertNameApply it will replace the B2 to B10 range I have already used in a formula with the name, My Sales. So what does InsertNamePaste do? Also, what does InsertNameLabel do? I thought I created labels just by typing them into the spreadsheet at the top of the column of data I want to label. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
What does InsertNameLabel & InsertNamePaste do?
Thanks, Ron. I understand what you said <insert<name<paste and about
the insert name label in the link you provided. I couldn't get it to work, though. No worries, though, I found this website http://en.allexperts.com/q/Excel-1059/Naming-Labels.htm to try to tell me the difference btw names and labels but I'm going to have to study b/c at first glance it's too convoluted. I appreciate your help b/c you did clear up what insert name label and insert name paste do. Thanks "Ron Coderre" wrote: <insert<name<paste displays a list of Named Ranges that you you can pick from to use in a formula. Since I use Named Ranges quite a bit, I just use the [F3] shortcut, instead. Example: If I have A2:A100 named: Sales I can sum those values by.... Type: =SUM( Press: [F3]....Select "Sales" from the list Type: ) Press: [ENTER] The resulting formula is: =SUM(Sales) I've never had much use for Label Ranges... but here's an explanation and example: http://www.bettersolutions.com/excel...E824631331.htm Does that help? Post back if you have more questions. Regards, Ron Microsoft MVP - Excel "Studebaker" wrote in message ... I typed in a label in B1 called My Sales. I used InsertNameCreate to create a named range for B2 to B10 with the My Sales label I typed as the named range. I understand that if I click InsertNameApply it will replace the B2 to B10 range I have already used in a formula with the name, My Sales. So what does InsertNamePaste do? Also, what does InsertNameLabel do? I thought I created labels just by typing them into the spreadsheet at the top of the column of data I want to label. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste and Insert | Excel Discussion (Misc queries) | |||
What does label do under Insert, Name, Label? | Excel Discussion (Misc queries) | |||
how is Insert, Name, Label different frm Accept labels in formula | Excel Discussion (Misc queries) | |||
Insert | Name | Label | Excel Discussion (Misc queries) | |||
What does Insert>name>LABEL option do ? | Excel Discussion (Misc queries) |