What does Insert>Name>Label & Insert>Name>Paste do?

  • Thread starter Thread starter Studebaker
  • Start date Start date
S

Studebaker

I typed in a label in B1 called My Sales. I used Insert>Name>Create 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 Insert>Name>Apply it will replace the B2 to B10
range I have already used in a formula with the name, My Sales. So what does
Insert>Name>Paste do?

Also, what does Insert>Name>Label 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
 
<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/EFC133/LE824631331.htm

Does that help?
Post back if you have more questions.

Regards,

Ron
Microsoft MVP - Excel
 
Thanks, Ron. I understand what you said re: <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 said:
<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/EFC133/LE824631331.htm

Does that help?
Post back if you have more questions.

Regards,

Ron
Microsoft MVP - Excel
Studebaker said:
I typed in a label in B1 called My Sales. I used Insert>Name>Create 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 Insert>Name>Apply it will replace the B2 to
B10
range I have already used in a formula with the name, My Sales. So what
does
Insert>Name>Paste do?

Also, what does Insert>Name>Label 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
Click to expand...
Click to expand...
 
Back
Top