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

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

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